Re: How can i create this formula

BobI provided you with the formula you need but for future reference
you need to implement the Order of Operations for calculations.
Arithmetic operations are preformed in the following order:

- Parentheses
- Powers/Exponents
- Multiplication and/or Division (left-to-right)
- Addition and/or Subtraction (left-to-right)

Here's the breakdown for your formula: Since multiplication is
preformed before addition you need to place the cell address of your
chosen cell + 50 in parentheses so it calculates first:

(<cell>+50)

If you want to add 17.5% to the total then multiplying the result by
17.5% will only give you 17.5% of the total. So you need to add 100%
of the total plus the percentage which would be (1+0.175) or 1.175:

(<cell>+50)*1.175

Then do the same for 5%:
(<cell>+50)*1.175*1.05

The above will work since multiplication is preformed from left to
right, but for clarity you can place each calculation in parentheses:
((<cell>+50)*1.175)*1.05
or
(((<cell>+50)*1.175)*1.05)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Rory" <Rory@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:84709418-5042-49F0-B3FB-8C3B84929423@xxxxxxxxxxxxxxxx
> Okay , i would like a formula to do the following,
> add 50 to a number in a chosen cell, then * this by 17.5% and add,
> then *
> that total by 5% and add then display the answer
> thanks in advance.
> Rory.


.

Relevant Pages

  • Re: Calculating sell price from several fields access 2003
    ... Search for Operator Precedence in the VBA help to determine the order of calculations. ... You may need to add parentheses around some of your expression if it is not calculating the way you wish. ... I have fields of cost_price, Ex_rate, Freight_Factor as percent, Margin as percent ...
    (microsoft.public.access.queries)
  • Re: OT:riddle me this
    ... >>> arithmetic operations, plus, minus, times and divide, and grouping by ... >>> parentheses? ...
    (rec.gambling.poker)
  • Re: Newbie! Programming Calculations
    ... At the bottom of the page there are these sample calculations: ... Is the number is the brackets calculated first? ... the parentheses indicate what happens first. ... The difference in order of evaluation is due to the parentheses. ...
    (comp.lang.ruby)
  • Re: 1000-200*4% add
    ... [I have included parentheses to make it clear ... to you what the priority of the arithmetic operations will be, ... David Biddulph ...
    (microsoft.public.excel.misc)
Quantcast