I seem have too many logical tests for my IF formula. Is there away around this? I have attached a sample to show the columns and rows I am using.
I need to find a formula for column D which covers the following:
If A1 is blank, then D1= blank.
If C1 is blank, then D1= blank.
If C1 is NOT blank AND E1 is blank, then D1=TODAY()-C1
If C1 is NOT blank and E1 is NOT blank, then D1= E1-C1
Last edited by amy1; 08-21-2024 at 05:41 AM.
Is this what you mean?
=IF(OR(A2="",C2=""),"",IF(AND(C2<>"",E2=""),TODAY()-C2,IF(AND(C2<>"",E2<>""),E2-C2,"")))
Is your forum profile up-to-date?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Another option
Please Login or Register to view this content.
Quang PT
As I see A column is not relevant...
Maybe: =IFERROR(MIN(E2,TODAY())-1/(1/C2),"")
Thank you for everybody that has replied to me, you make this look so easy!! So helpful, thank you
Glad to have helped.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks