Increasing or decreasing an amount by percentages

[XxBrawlerxX]

What would be the correct formula for 1 & 2?

Formula
=D2*0.13+D2

C2 = 11.121758 (random number)
D2 = 22.32 (random number)

Formula 1:
22.32 (D2) + 13% - 2.98% - 22.32 (D2) = 2.15

Formula 2:
22.32 (D2) + 13% - 2.98% - 22.32 (D2) = 2.15 x 11.121758 (C2) = 23.9117797

[RusselB]

Welcome to the Forums.
To make this as simple as I can, I'm going to show this in individual steps for the first formula.
You should be able to apply the steps to the second, and, if you want, condense them to use fewer columns on your own.
D2 = 22.32
E2

Code: Select all

=13%*d2

Now for F2 there are two possibilities, I'm going to give you both and you can determine which one is the correct one for the results you want.
F2(a)

Code: Select all

-2.98%*D2

F2(b)

Code: Select all

-2.98%*(D2+E2)

G2

Code: Select all

=e2+f2

For the second formula, you only have one extra calculation, which can be easily incorporated into the G2 code given above, unless you want/need to see the results of the G2 code as well as the final results, in which case you need one more column.

[XxBrawlerxX]

What would be the formula for the following cells:
E2, F3 and G2

D2 = 22.32 (random number)
E2 = 13% (random number)
F3 = 2.98% (random number)
G2 = TOTAL

D2+E2-F2-D2=G2

Example:

22.32 (D2) + 13% (E2) - 2.98% (F2) - 22.32 (D2) = 2.15 (G2)

[RusselB]

Your second post is almost identical to your first.
One thing I don't know is if the calculation of the 2nd percentage (F2) is based on just the base number (D2) or the base number and the first percentage (D2 + E2)
That said, there are really two different options, both of which I listed in my earlier reply.

[XxBrawlerxX]

Meaning how would i change "13%" or "2.98%" to a different number that I would click on cell and backspace and enter a different number.

Code: Select all

=13%*d2

[RusselB]

Simply substitute the cell address that contains the percentage number with the hard coded percentage in the various formula(s)

[robleyd]

Put the variable percentage rate in a separate cell and reference that cell from your formulae. That way if you want to alter the rate for a number of formulae you only need to modify it in one place.

[Hagar Delest]

Please have a look at the [Tutorial] Ten concepts that every Calc user should know, especially §8.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.