| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use an IF statement to reference 2 different cells?
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 | |||
| Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Reference to cells using autofilter problem | Excel Worksheet Functions | |||
| How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
Hybrid Mode
