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
|