percentage help

[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

 

[Don Guillett]

would
=a1*.78 help
or
=5700*.78

 

[Bob Phillips]

=5700*(1-22%)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Juan Sanchez]

Assuming you have 5700 in cell A1 and 22 in cell B1 in
cell C1 type:
=(1-b1/100)*A1

Cheers
Juan

 

[Jonuhs]

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

 

[Juan Sanchez]

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

 

[Jonuhs]

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

 

[Juan Sanchez]

Just input on E2 this:

=b2-e2

then pull down again...

cheers
Juan