View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Skeeterj Skeeterj is offline
external usenet poster
 
Posts: 8
Default 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.