Re: 1000-200*4% add

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You haven't made it clear what you want.
Perhaps one of the following? [I have included parentheses to make it clear
to you what the priority of the arithmetic operations will be, but in some
cases the parentheses can be omitted because of the defined precedence of
the operators.]

=A1-(B1*4%)
=(A1-B1)*4%
=A1-(B1+(B1*4%)) or =A1-(B1*(1+4%))
=(A1-B1)*(1+4%)
--
David Biddulph

"deepak" <deepak@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:647CC9F2-7A33-4E1C-B3EB-271A5C6300B4@xxxxxxxxxxxxxxxx
pls give me answer of this quetion.

a b c
1000 - 200 A-b+4%add


.

Relevant Pages

  • Re: How can i create this formula
    ... you need to implement the Order of Operations for calculations. ... Arithmetic operations are preformed in the following order: ... chosen cell + 50 in parentheses so it calculates first: ... MVP FAQ site: http://mvps.org/ ...
    (microsoft.public.office.misc)
  • Re: The nature of motion, anyone have a clue?
    ... For pity's sake learn to use parentheses. ... The objective is to remind you of the order of arithmetic operations, which is something you should have learned in the 4th grade. ... Conrad J Countess ...
    (sci.physics)
  • Re: OT:riddle me this
    ... >>> arithmetic operations, plus, minus, times and divide, and grouping by ... >>> parentheses? ...
    (rec.gambling.poker)
  • Re: how do I write an IF/other statement to cut off time data?
    ... "David Biddulph" wrote: ... Your OR function has opened the parentheses for this list of arguments, ... Brevity is the soul of wit. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how do I write an IF/other statement to cut off time data?
    ... "David Biddulph" wrote: ... Your OR function has opened the parentheses for this list of arguments, ... Brevity is the soul of wit. ...
    (microsoft.public.excel.worksheet.functions)