More Efficient Formula

Svgmassive
Svgmassive used Ask the Experts™
on
I am looking for a more efficient function,Any suggestions?
=IF($E14="","",IF($E14=0,"",IF($Z14="",$T14/1/$K14,$T14/$Z14/$K14)))
Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014

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

Open in new window

Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
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...
=IF($E14=0,"",IF($Z14="",$T14/1/$K14,$T14/$Z14/$K14))

Open in new window

Finance Analyst
Commented:
Or you can use the OR and IFERROR functions to handle blanks:

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

The multiple division will be calculated in sequential order, therefore $T14/1/$K14 will be same as $T14/$K14.

Should there be brackets around the Z14/K14 section?

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial