Mar 31 2020 09:45 AM
Hi
I have the 2 formula's below which work great on there own
=IF(J40<=TODAY(),"Expired","Live")
=IF(ISBLANK(J31),"","Pending")
How ever I am trying to put them together as below but doesn't seem to be working
=IF(ISBLANK(J42),"","Pending",IF(OR(J42)<=TODAY(),"Expired","Live"))
Any help would be great
Thanks
Mar 31 2020 10:54 AM
Take the "OR" out. That's in essence what the "else" clause of an IF function is ALREADY asking.
By nesting that second IF in the first, you are already saying, "on the other hand, if J42 isn't blank, then evaluate this IF clause"
Mar 31 2020 11:12 AM
In addition - that's even not nested IF, 3 arguments for the first IF(). That's since logic is not defined - will we check next conditions if J31 is empty, or if not empty, or what.
Apr 01 2020 04:42 AM
Hi
Thanks for the reply. I have tried taking out the OR, Tried lots of different thing but still unable to get it to work.
Thanks for your assistance anyway
Apr 01 2020 05:12 AM
Well, as @Sergei Baklan correctly noted, in addition to needing to remove the redundant OR, you hadn't correctly nested the second IF within the first, the inner within the outer.
Try this. I just did and it worked.
=IF(ISBLANK(J42),"Pending",IF(J42<=TODAY(),"Expired","Live"))
Apr 01 2020 05:21 AM