IF Cell is blank, calculate, if cell isn't blank, leave blank
I have this
=IF(ISBLANK(L2)=TRUE,AA2-I2,L2-I2)
If L2 Complete Date is blank it calculates the number of days between today AA2 and the Log date I2
Now I've been asked that if Complete date is not blank, then make my result be a blank
Maybe I just need more coffee (_)3
Last edited by amthyst826; 09-04-2015 at 11:00 AM. Reason: Resolved
Either replace the last part of your formula with "" to give:
Formula:
Please Login or Register to view this content.
or just use this:
Formula:Please Login or Register to view this content.
Regards,
Aardigspook
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.
Awesome! Thanks so much
You're welcome and thanks for the rep.
Regards,
Aardigspook
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks