More Efficient Formula

Svgmassive used Ask the Experts™
I am looking for a more efficient function,Any suggestions?
Watch Question

Do more with

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


Open in new window

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

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

Open in new window

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


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?


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