Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use an IF statement to reference 2 different cells?
Its not exactly clear what you're trying to do, but you can probably get what
you want with embedded IF statements. e.g. IF(B24=0.01,6,IF(B25=0.01,8,5)) If you want to test whether both B24=0 and B25=0, use the AND() statement: IF(AND(B24=0,B25=0), 8,5) Similarly, if you want to know if either B24 or B25 =0 IF(OR(B24=0,B25=0),6,5) "Shan" wrote: I have the following formula in cell I39 which works great and does what it is supposed to do: =IF(B24=0.01,5+1,5) However, I also want this formula to reference cell B25 as well with a little different calculation: =IF(B25=0.01,5+3,5) How can I combine these 2 formulas so it will check both B24 and B25 and return 1 result in cell I39? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Removing $$ Reference in cells | Excel Worksheet Functions | |||
I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) |