IF OR with 3 Conditions

[DPXCV]

Looking for some help on finalizing a formula. The below formula will return a value of "NULL" if either A10 or B10 is blank, or if both have values will return a value of today's date minus cell B10 (currently shown). However, once cell C10 is populated with a date, I would like cell D10 to change to "Ack", so long as there is a date in cells A10 - C10.


=IF(OR(A10="",B10=""),"NULL",TODAY()-B10)

 

[Fluff]

Hi & welcome to MrExcel.
How about

=if(c10<>"","Ack",IF(OR(A10="",B10=""),"NULL",TODAY()-B10))

Or maybe

=IF(OR(A10="",B10=""),"NULL",if(c10<>"","Ack",TODAY()-B10)))

 

[DPXCV]

Hi & welcome to MrExcel.
How about

=if(c10<>"","Ack",IF(OR(A10="",B10=""),"NULL",TODAY()-B10))

Or maybe

=IF(OR(A10="",B10=""),"NULL",if(c10<>"","Ack",TODAY()-B10)))

I was putting the ack at the end instead of the beginning, thanks.

 

[Fluff]

You're welcome & thanks for the feedback.