• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Simplify Formula

cyliyu

Member
Need some advise.
Can I simplify the following formula?

=IF(E4="","",(IF(F4="","",(IF(T4="","",IF(T4="∞","",(IF(T4>=180,"Yes",""))))))))

1) Check if column E4 and F4 are empty, If they are, return a blank space. then
2) Check if column T4 is not empty and not infinity, if it is, return a blank space too. else
3) perform the last If statement.
 
This I'm almost certain this will do it:
Code:
=IF(OR(E4="",F4="",T4="",T4="∞"),"",IF(T4>=180,"Yes",""))
but you could also test:
Code:
=IF(OR(E4="",F4="",T4="",T4="∞",T4<180),"","Yes")
 
Back
Top