Notifications
Clear all
Topic starter
Hi
I need to create an if formula to do the following:
if date in column a is blank use date in column b, if date in column a is greater than date in column b use date in column a, if date in column b is greater than date in column a use date in column b, if columns a and b are blank leave as blank
presume this can be done as nested formulas, but at the moment my mind is blank
any help would be appreciated
Posted : 28/11/2018 10:31 am
Hi Catherine
You can try
=IF(AND(A1+B1)=0,"",MAX(A1,B1))
You did not mention what if A1=B1 and both are not blanks? What do you want to do with it?
Sunny
Posted : 28/11/2018 1:43 pm