OR options in IF statement

  • Thread starter Thread starter Skeeterj
  • Start date Start date
S

Skeeterj

I'm trying to look at two cells, and if either has a date in it I want that
date in a third cell (where the formula is).

This formula works: =IF(COUNT(tab!$AF6)=1,MAX(tab!$AF6),"")

for checking one cell, but I also want to check (tab!AQ6) for a date. Any
suggestions?

Thanks.
 
In general you can have multiple logical tests in an IF statement

=IF(AND(test1,test2),action if true,action if false)

=IF(AND(COUNT(tab!$AF6)=1,tab!AQ6 = Today()),MAX(tab!$AF6,"")

However your test if AF6 = 1, is true then MAX of it will also be 1 !
 
Back
Top