Question about Microsoft Excel for PC

1 Answer

Formula hi, i got a formula like this, =IF(AND(I34="Labour",(AND(J34="D"))),P34*$K$4,IF(AND(I34="Labour",(AND(J34="N"))),P34*$K$5,IF(AND(I34="Labour",(AND(J34="W"))),P34*$K$6,IF(AND(I34="S Labour",(AND(J34="D"))),P34*$K$7,IF(AND(I34="S Labour",(AND(J34="N"))),P34*$K$8,IF(AND(I34="S Labour",(AND(J34="W"))),P34*$K$9,IF(AND(I34="MO",((J34="D"))),P34*$K$10))))))) But when i add another it like this, =IF(AND(I34="Labour",(AND(J34="D"))),P34*$K$4,IF(AND(I34="Labour",(AND(J34="N"))),P34*$K$5,IF(AND(I34="Labour",(AND(J34="W"))),P34*$K$6,IF(AND(I34="S Labour",(AND(J34="D"))),P34*$K$7,IF(AND(I34="S Labour",(AND(J34="N"))),P34*$K$8,IF(AND(I34="S Labour",(AND(J34="W"))),P34*$K$9,IF(AND(I34="MO",((J34="D"))),P34*$K$10,IF(AND(I34="MO",((J34="N"))),P34*$K$11,)))))))))))))) The excel cant accept it, please can anyone in this, or how to solve this out, i still got 36 different thing to go. Many Thanks.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 108 Answers
Re: Formula

What you have posted is not a complete picture (nor statement) of the problem. The syntax I see (in briefly looking at it) appears okay.
Suggest you start problem is I get the following screen (refusing to accept my input) when I try to enter....(what). Also, there are relationship tools which will show you the problem...(in RED)....just backtrack. Read the help menu for this information.

Posted on Jan 24, 2008

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:



In the cell that you want the result to appear in, enter the appropriate formula from the following examples.
How to Count the Occurrences of a Number
Use this formula
where range is the range that you want to search, and number is the number that you want to count.
NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
How to Count the Occurrences of a Text String
Method 1
Use this formula
where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).
NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
Method 2
Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula
where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).
NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
Wildcard characters can be used within the COUNTIF function.
The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:
The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."

on Nov 11, 2013 | Microsoft Excel Business & Productivity...

1 Answer

Problem was found in Micorsoft excel 2003. When I copy the formula from one (original) cell to another (new) cell, the formula in the new cell has updated but the value show on the new cell was the...

Once you have copy the cell from where the formula cam from, on the destination cell,
go to
1. Edit
2. Paste Special
3. Formula.
4. Press Enter

This should resolve your problem. Regards.

Aug 11, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

Why don't formulas copy from cell to cell?

Step 1
Determine what formula is to be copied and to what location it is to be copied. Carefully consider the cells that are to be referenced in the formula and that they are indeed the cells that contain the information to be acted upon by this formula.
Step 2
Highlight a cell that has the formula in it and click the right mouse button. Select the "Copy" option.
Step 3
Move to the new destination cell for this formula, right click the mouse button and select "Paste."
Step 4
Check the first cell to make sure the correct calculation has been performed. If not, check the formula that appears in the cell that contains the result of the formula that was just copied. Make sure that the formula references the correct cells. If not, correct the formula and then copy the corrected formula to the rest of the cells that should have this formula applied to them.

The only time I have seen this not work is when the cells/pages are protected.

Some formulas will require references to multiple pages or a workbook. Make sure that the absolute cell address is used for specific numbers and those that are to be applied to subsequent cell addresses are clearly denoted by the use of "$" in the cell address.

Dec 17, 2009 | Microsoft Office Home and Student 2007...

2 Answers

Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Excel will not displaying the results of a trend array formula

Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

2 Answers


u know vlookup function,then piviot table
u know na tell short formula

Dec 14, 2007 | Microsoft Excel for PC

1 Answer

Percentage formula


Since you are asking for the formula, it depends where your values are (cell). Please refer to the example below.


Good luck and kind regards.

Dec 09, 2007 | Business & Productivity Software

1 Answer

Getting the excel formula

Suppose the value for $ is stored in cell A3. Your formula would look like this: =(A3+A3*0.25)*1.5

The equals sign at the beginning of the formula is necessary. And if you want the result to be formatted as currency, you can do so by right-clicking the cell or column, format cell, number tab, choose currency.

Nov 15, 2007 | Business & Productivity Software

1 Answer

Excel formula

Relative cell reference is address of cell , when copied from one cell to another gets changed automatically.

e.g. Put formula in cell c5 as A5+1 when you copy this from c5 to c6 the address of A5 will automatically changed to A6.


Absolute Cell Reference

As above now put formula in cell C5 as $A$5+1 ,now copy this formula from C5 to C6 if you this formula youwill find cell Address of A5 does not changed.


Mixed Cell Reference:

If we put Dollar ($) sign before Alphabetic cell address i.e.$c5 then even if you copy this formula in any cell , coloumn (c)  will remains constant.

Similarly if we put Dollar ($) sign before Numeric cell address i.e.c$5  then you copy this formula in any cell row address of the cell remains same.(5).


Pl elobarate on remaining two points 'Specific order of formulas ' and 'advance formulas,

Sep 15, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

170 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides