Excel 2007 IF function

Solved/Closed
Nikki - Jun 25, 2012 at 09:35 AM
 Nikki - Jun 25, 2012 at 10:41 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jun 25, 2012 at 09:52 AM
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
0
Thank you very much. I see what I was doing wrong.
0