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

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

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

    Scholar:

    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 with...my 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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

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

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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.
https://absolutelyscooters.net/service-manuals.html
CPI Scooter Parts Racing Planet USA
CPI Formula 50 2009
first test driver cpi formula
Tips and Tricks for Motorcyclists

Btw, I’m available to help over the phone in case u need at https://www.6ya.com/expert/gregg_c0ec1df182c7330e


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.

Note: 
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 ALL SHORT FORMULA


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

Dec 14, 2007 | Microsoft Excel for PC

1 Answer

Percentage formula


Hi,

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

d770346.jpg

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:

174 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

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

Answer questions

Manuals & User Guides

Loading...