Avoid repeating inner equation in a logical expression

Hi there,

I have a complicated equation which I'd like to avoid duplicating it in my formula. However the only way I have been able to achieve what I need is to write the entire formula like this:

= If ( someBigEquation=0, "", someBigEquation)

More specifically, here is my formula:

Please Login or Register  to view this content.

In Excel 2016 I could use the function IFS() however I only have Excel 2013.

Is there a way to retain the functionality of my formula without having to repeat the someBigEquation?
Thanks in advance,
Michelle

Just format cell not to show 0.

Right click -> Format cells -> Custom

Formula:

Please Login or Register  to view this content.

Take just your 'someBigEquation' formula and change the celformat in
0;-0;;

Is there a way to retain the functionality of my formula without having to repeat the someBigEquation?

My suggestion will probably not be well received, but I would invoke the use of evil and heretical helper cells. Put your somebigequation into a cell as is, then your IF() function in a separate cell would be =if(reference=0,"",reference)