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/
