Percentages in formulas

walkera

New Member
I posted a similar problem earlier, but now I have another problem!
I need a formula to work out a percentage of a total, however this percentage can change and is not fixed. For example.

I need to minus 12% from the total of £8.75. The percentage can differ. How can I do this?

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
What are the rules involved that changed the percentage... and what are the percentages involved?

OK
The second part of my original answer can be used in reverse although you don't say if the Percentages AND values change.

Let's say

Col A = Amount
Col B = Percentage

The formula you need in Col C is

(A1/100)*(100-B1)

If the Percentage stays the same put the percentage in B1
and in Col B the formula in Col C needs to be

(A1/100)*(100-\$B\$1)

If the Amount stays the same put the Amount in A1
and in Col B the formula in Col C needs to be

(\$A\$1/100)*(100-B1)

That OK for you?

DaveA

OK
The second part of my original answer can be used in reverse although you don't say if the Percentages AND values change.

Let's say

Col A = Amount
Col B = Percentage

The formula you need in Col C is

(A1/100)*(100-B1)

If the Percentage stays the same put the percentage in B1 the formula in Col C needs to be

(A1/100)*(100-\$B\$1)

If the Amount stays the same put the Amount in A1 the formula in Col C needs to be

(\$A\$1/100)*(100-B1)

That OK for you?

DaveA
This message was edited by applebyd on 2002-08-28 07:11

THANKS FOR THE HELP I HAVE MANAGED TO SORT I
THANKS AGAIN, ALI.

Replies
2
Views
219
Replies
1
Views
208
Replies
1
Views
200
Replies
5
Views
393
Replies
2
Views
717

1,221,090
Messages
6,157,873
Members
451,447
Latest member

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back