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.
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.