Help with IF formula

[BitterGreg]

I am in need of some assistance with an if formula that is not working for me. I am guessing the issue is with my parentheses. Below is my original formula that works when data is input, and then below that is my unsuccessful attempt at the formula to have a - inserted when there is no data on the table.

Original Formula - =((T118/SUM(T118:T132))*0.41)*100

Unsuccessful IF formula - =if(iserror((T118/SUM(T118:T132))*0.41)*100),”-“, (T118/SUM(T118:T132))*0.41)*100))

Any assistance would be greatly appreciated.

Greg

[BadlySpelledBuoy]

=iferror(((t118/sum(t118:t132))*0.41)*100),"-")

[ChemistB]

Try

=IF(ISERROR((T118/SUM(T118:T132))*0.41*100), "-", (T118/SUM(T118:T132))*0.41*100)

With Excel 2013, you could use IFERROR
=IFERROR(T118/SUM(T118:T132)*0.41*100, "-")

[BitterGreg]

=iferror(((t118/sum(t118:t132))*0.41)*100),"-")

Thank you for the reply but it is telling me "There are to few functions for this argument"

[BitterGreg]

Try

=IF(ISERROR((T118/SUM(T118:T132))*0.41*100), "-", (T118/SUM(T118:T132))*0.41*100)

With Excel 2013, you could use IFERROR
=IFERROR(T118/SUM(T118:T132)*0.41*100, "-")

This seem to have worked. I used the 2013 formula.

with out having the parentheses around the *.41 and *100, how does it know to calculate them in the correct order?

[ChemistB]

It uses the "Please Excuse My Dear Aunt Sally" method (Parentheses, Exponents, Multiplication and Division, Addition and Subtraction.
Unless you wanted the 0.41 or the 100 in the denominator of the previous term, it doesn't matter if it does the multiplication or division first.
Sometimes parentheses are just nice to have to break things up a little and make them clearer.

[ianahner]

This seem to have worked. I used the 2013 formula.

with out having the parentheses around the *.41 and *100, how does it know to calculate them in the correct order?

A small little addition to keep in mind. When parentheses are not required AND you are having a problem with excel, nuke them. I have had excel throw tantrums over extra parentheses more than once. Even if they are technically correct, sometimes excel tries to read them as functional parentheses rather than arithmetic parentheses.

In the case above, as was posted by the guy above me, Multiplication is commutative just as addition is. 5*.41*100 is exactly the same as 5*100*.45 just as 1+2+3=1+3+2 Don't let the 'division by multiplication' thing confuse you. That .41 is already 41/100 and so the non-commutative portion of the arithmetic expression is already solved. Multiplying by .41 is like putting the 41/100 inside parentheses.

Don't worry about the arithmetic stuff, I have been through several years of college calculus and still screw up addition on a regular basis.

Cheers!

[BitterGreg]

Thank you everyone that really helped