Excel 2007 IF function [Solved/Closed]

Report
-
 Nikki -
Hello,

Need formula to say if cell has NA put 0 but if the cell has a date (yy,mm,dd) then subtract cell L1 from cell E1. Trying to determine how many days from date form received until date auth put in.

I have formulas to make each function happen separately but can't put it all together so far.


=IF(L11="NA","0")

=IF(L16=DATE(2012,6,3),"",L16-E16)

Thanks in advance
Nikki

1 reply

Posts
2660
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 29, 2020
442
Hi Nikki,

Your story contradicts your formula's a little so I will just look at the formula's and merge them:

=IF(L11="NA","0",IF(L16=DATE(2012,6,3),"",L16-E16))

Best regards,
Trowa
Thank you very much. I see what I was doing wrong.