Hi, I can't get my formula to work, please open the attachment.
The formulas are in D3:D6.
I would expect D3 to be "No", D4 and D5 to be "No" and D6 to be "Yes"
Where am I going wrong? I feel like I have covered all scenarios and that the required conditions are being met
Many thanks
Drum
The three last dates are all bigger than today, soo ...
This may be what you mean:
=IF(A3>TODAY(),"n/a",IF(AND(B3="Yes",C3<=A3),"Yes",IF(AND(B3="Yes",C3>A3),"No",IF(B3="No","No",""))))
Last edited by AliGW; 09-15-2022 at 11:52 AM.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try:Formula:
Please Login or Register to view this content.
Note that your dates are 2023 hence n/a outcomes.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Genius. Thanks ALIGWOriginally Posted by AliGW
Thank you, I missed this!
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
Thank you, I have done that to both of your replies
You're welcome. 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