Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple conditional formula
Hi, I'm stuck on a formula I'm trying to add to my spreadsheet. Essentially,
I need the formula to do the following: In the formula cell (D1), If A1 is 0, then I need the answer to be : $40.00 if B1 says X $30.00 if B1 says Y $30.00 if B1 says Z and so on. I tried the following and it's not working because I can't figure out how to get the formula to check A1 for a value before it runs the IF test. I've edited the last bit of the formula (etc.). I have additional if tests, not etc. What do I need to add to this or should I scrap it and try a straight Lookup? All help is greatly appreciated! =IF(B1="X",40,IF(B1="Y",30,IF(B1="Z",etc.))))) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
how to create a multiple conditional formula | Excel Discussion (Misc queries) |