View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Edmund
 
Posts: n/a
Default formulas containing more than one 'operator'

=(((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
--
Edmund
(Using Excel XP)


"Louise" wrote:

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