Re: 1000-200*4% add

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: 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)
  • Re: "Too many arguements for this function"....ohh noooo....
    ... "David Biddulph" wrote: ... You can also throw away the unnecessary parentheses, ... array formula, but I haven't figured them out enough yet to write one ... The cells in question are blank and if the user puts in a ...
    (microsoft.public.excel.worksheet.functions)