Thread: Can I use an IF statement to reference 2 different cells?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shan Shan is offline
external usenet poster
  
Posts: 14
Default 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 With QuoteReply With Quote