percentage help

  • Thread starter Thread starter Jonuhs
  • Start date Start date
J

Jonuhs

How would I make a function that would allow me to subtract a percentag
from a whole number?

Here is an example:

I have 5700 dollars and i want to take out 22%

can I multiply 5700 and 22 then subtract the sum of the firs
equation?

any help would be greatlky appreciated
 
=5700*(1-22%)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Assuming you have 5700 in cell A1 and 22 in cell B1 in
cell C1 type:
=(1-b1/100)*A1

Cheers
Juan
 
SUper ok now how would I do it for a column?
a1 will be 5700 b1 will be percentage and c1 will be answe
 
Same thing...

Formula will be =(1-B1/100)*a1 in C1
then using the fill handle... (little black square at the
bottom-right corner of the cell) in C1, drag to the end of
your data column.

If theres alot of data, assuming there are no blank cells,
just double click on the fill handle and it will take it
down to the last cell with values...

Cheers
Juan
 
Got it Thank you sir that was very nice of you to help.
I have one more problem.

I need to subtract d2-31 from b2-31 each cell sperately

here is what is looks like now

drivers name (a1) gross income (b1) salary% (c1) total (d1) withhel
amount (e1)

Io need the amount in whole number that the % is taking ou
 
Back
Top