ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I use an IF statement to reference 2 different cells? (https://www.excelbanter.com/excel-worksheet-functions/121069-can-i-use-if-statement-reference-2-different-cells.html)

Shan

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