Forum

Notifications
Clear all

If formula

2 Posts
2 Users
0 Reactions
66 Views
(@manicomc2304)
Posts: 1
New Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
Share: