Subtracting a percentage of a number?

  • Thread starter Thread starter Steven Dedrick
  • Start date Start date
S

Steven Dedrick

Hey there all,

It is Monday today and my brain does not seem to be working.

I have a series of numbers in which I need the formula to give me th
subsequent percentage removed from these numbers, for example:

3,761- 50.17% this should in theory give you roughly 1,850 for the en
result but I cannot get excel to give me anything except 3,760.

I hope I am making sense. So what I need is the formula to do 3,761
50.17% of itself, but for some reason I just cannot get it today.

Any help would be great
 
If you want to subtract 50.17% of a number, from a number you actually want
100% -50.17% = 49,83% of the number. So with 3761 in A1 and 50.17% in B1
enter the formula:

=A1*(1-B1)

which will give an answer of 1874.106

HTH

Sandy
 
Steven

=3671*(100-50.17)/100 returns 1829.26

OR

=3761*(1-.5017) returns 1829.26

Gord Dibben Excel MVP
 
Back
Top