Re: formulas containing more than one 'operator'


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?action=getinfo&userid=21059
View this thread: http://www.excelforum.com/showthread.php?threadid=542051

.

Relevant Pages

  • Re: Overlaping conditions....may be
    ... It returns the higher value of your calculation and zero so that if the ... I have also removed several brackets, (there is no need to enclose 0.25 ... The result was in minus instead of 0. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Calculation Field Comparing Calculation Fields?
    ... Calculation Field, or perhaps there is a nifty trick to do so? ... My first guess would be that Eric doesn't have any brackets on his test. ... I'm not sure what the precedence order is here, so the first test could ... perhaps it is the correct related field, ...
    (comp.databases.filemaker)
  • Re: Overlaping conditions....may be
    ... It returns the higher value of your calculation and zero so that if the ... and the crowning place of kings ... I have also removed several brackets, (there is no need to enclose 0.25 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to pass several variables to a macro using OnAction
    ... Put the second and subsequent parameters outside of the brackets. ... Ziado Wrote: ... Bryan Hessey ...
    (microsoft.public.excel)
  • Re: formulas dont work anymore
    ... Did you check Tools, Options, Calculation and check Automatic was ... john Wrote: ... > I have made a sheet with some formula's in it and they used to work ... Bryan Hessey ...
    (microsoft.public.excel.misc)