Svgmassive

asked on

# More Efficient Formula

I am looking for a more efficient function,Any suggestions?

=IF($E14="","",IF($E14=0,"",IF($Z14="",$T14/1/$K14,$T14/$Z14/$K14)))

Thanks

=IF($E14="","",IF($E14=0,"

Thanks

The condition $E14="" will be evaluated to be False if E14 is 0 but the condition $E14=0 will be evaluated to be True if the E14 is either blank or contains 0. So checking $E14=0 only is more than enough.

You may rewrite your formula as below...

You may rewrite your formula as below...

`=IF($E14=0,"",IF($Z14="",$T14/1/$K14,$T14/$Z14/$K14))`

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Open in new window