Maintaining order of operations with out parentheses

[tobysdhc]

Hello all,

I am trying to use the IFERROR formula below

=IFERROR(C15+C16+C17)/C21,NA())

Excel is using the parentheses, for the order of operations, to close the IFERROR formula. Is there a way to maintain order of operations, without parentheses?

Thanks,

 

[Joe4]

The number of right parentheses must match the number of left parentheses.
There is a set of parentheses for the IFERROR, and one for your SUM (since you want to add all the value before dividing). You are missing a right parend, i.e.

[COLOR=#333333]=IFERROR((C15+C16+C17)/C21,NA())[/COLOR]

You could likewise use:

[COLOR=#333333]=IFERROR(SUM(C15:C17)/C21,NA())[/COLOR]

or

[COLOR=#333333]=IF(C21=0,NA(),SUM(C15:C17)/C21)[/COLOR]

You really cannot get around it without using parentheses. But why is that really a concern?

 

[tobysdhc]

Thank you for the help! Worked Great!

 

[Joe4]

You are welcome!