![]() |
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? |
All times are GMT +1. The time now is 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com