Excel - If but three possible outcomes

June 20, 2011 at 06:35:43
Specs: Windows XP
Hi there

Looking to set up an If formula, normally have no problems with them, but this one has me really confused.

I have a large list of dates, but what I want is that if say F4 was older than 90 days from today it would show "lapsed" whereas if F4 was todays date or was in the future, it would say "member" but if it is between the two, so older than today but less than 90 days old, it would say "grace"

Is it possible to do this??

Thanks in advance

See More: Excel - If but three possible outcomes

Report •

June 20, 2011 at 11:05:59
Is this what you are looking for?


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

June 20, 2011 at 13:43:36
Thank you so much!

"If" formulas are normally a doddle for me, I swear this pregnancy brain will be the death of me!

Report •
Related Solutions

Ask Question