formulas containing more than one 'operator'

L

Louise

Hi all

I have a formula and am struggling to get the correct answer. As the
calculation contains more than one 'operator, i need to use brackets,
however, I'm not entirely sure where these should go.

My calculation is =10+10*2+2*10

My total should therefore be 420.

Where do the brackets go in order to get to the right answer???

Thank you.
Louise
 
B

Bryan Hessey

Try

=((10+10)*2+2)*10

--
Hi all

I have a formula and am struggling to get the correct answer. As the
calculation contains more than one 'operator, i need to use brackets,
however, I'm not entirely sure where these should go.

My calculation is =10+10*2+2*10

My total should therefore be 420.

Where do the brackets go in order to get to the right answer???

Thank you.
Louise
Click to expand...
 
E

Edmund

=(((10+10)*2)+2)*10

Try pressing F1 & read up Excel Help. You may like to search the help for
title "The order in which Microsoft Excel performs operations in formulas"

HTH
 
Top