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

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

Try

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

--

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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=542051