| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement
I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS
Cell Q73 reads =IF(L73=300000,"3000",IF(L73=270000,"2700",IF(L7 3=240000,"2400",IF(L73=200000,"2000","0")))) Cell Q74 reads IF(L74=200000,"3000",IF(L74=170,000,"2700",IF(L7 4=140000,"2400",IF(L74)=100000,"2100","0")))) Cell F66 has the number 1 Cell F67 has the number 2 I am trying to write a formula that says IF F66 is a "1" use the formula in cell Q73 and if F66 is a "2" use the formula in Q74. I keep getting a 0 for the answer so I figure it is not reading the formula because I have tested the formula and it works. Any help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| If statement or lookup statement not sure | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Threaded Mode
