formulas containing more than one 'operator'

[Guest]

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

 

[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

 

[Guest]

=(((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