Subtract a %

[JTL9161]

This seems simple but I just cannot figure out the formula

1 Number take 25% of that number

Number 300,000
25% 75,000

Need to get to this number is last cell 300,000-75,000 = 225,000

Need to take the % away from the beginning number.

Thanks,
James

 

[Joe4]

Use a formula like this:
= Original Number * (1 - percentage to take away)

i.e.
=300000 * (1 - .25)

If original amount is in cell A1 and percentage to take away is in cell B1 (and entered as a percentage), it would look like this:

=A1*(1-B1)

If cell B1 has "25" in it instead of "25%", then you will probably need to divide it by 100, i.e.

=A1*(1-(B1/100))

 

[JTL9161]

Perfect thanks.

 

[Joe4]

You are welcome.
Glad I was able to help!