Highlighted
New Contributor

# Formula

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

5 Replies
Highlighted

# Re: Formula

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"

Highlighted

# Re: Formula

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.

Highlighted

# Re: Formula

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.

Highlighted

# Re: Formula

@Gary-Taylorwimpey

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"))

Highlighted

# Re: Formula

@mathetes

That's great

Thanks for that, worked a treat.

Much Appreciated all