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

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


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


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



Related Questions:

1 Answer

Formula in excel 2013 for if statement

google-- user manual for excel-- and you will find that information in the 900 pages of the pdf version download

Oct 17, 2017 | Excel Computers & Internet

1 Answer

Hi, My formula will not give me the correct sum when I drag it down into new columns even though the formula is correct. Please advise

What happens if you copy the formula from one cell and paste it into another? Sometimes formulas don't drag correctly. This can happen especially when you have more complex formulas. Another thing that can throw off the drag and drop copying of formulas are hidden rows or columns.
If a copy paste doesn't fix the issue than reply with the exact formula and a snippet of your data so I can troubleshoot it better.

Apr 04, 2017 | The Computers & Internet

1 Answer

Cpi formula r

Hi, Sparl1 sorry you can't find the first and best tool you ever bought for your CPI despair not for a mere $0 you can download another one. For more information about your issue and free downloads that you will need please visit the websites below. Good luck and have a nice day.
CPI Scooter Parts Racing Planet USA
CPI Formula 50 2009
first test driver cpi formula
Tips and Tricks for Motorcyclists

Feb 08, 2012 | 2008 Cpi Formula R

1 Answer

My baby girl is now 13 months old. I'm still feeding her Nestle Gerber "protect plus" formula around 500ml/day. Nurses have recommended me to switch her to cow's milk because formula would give...

Hi, Babies who are taking to solids normally should not be on formula after a year. The nurses were right, but I understand your anxiety in trusting them. I am however, a mother of almost 10 babies! No one stayed on formula past a year. My paternal grandmother (retired dir. of nursing) and my maternal grandmother(greatest mother on earth) agree! You may want to start week by week adding 2oz of cow or almond milk (whatever you drink-just not skim) to the formula she is already drinking just to keep an eye on allergies and to ease her little belly into reg. milk until she is taking 100% milk.

Feb 11, 2011 | Nestle Good Start Gentle Plus Infant...

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


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 | Computers & Internet

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 | Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

171 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18417 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides