OR options in IF statement
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.
|