I want to know how to multiply a single cell by a percentage.

ie: 2000.00 x 17.5% or 2500.59 x 30%

Does anybody know how to do this, appreciate your responses.

Try,

For 30%
=A1*1.3

For 17.5%
=A1*1.175

Mike


"jjbits4u" wrote:

I want to know how to multiply a single cell by a percentage.

ie: 2000.00 x 17.5% or 2500.59 x 30%

Does anybody know how to do this, appreciate your responses.

have notice that on the Mike's answer you will add 17,5% or 30% to the
amount, to have inly 30% of a value use

a1*0.3

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Mike H" escreveu:

Try,

For 30%
=A1*1.3

For 17.5%
=A1*1.175

Mike


"jjbits4u" wrote:

I want to know how to multiply a single cell by a percentage.

ie: 2000.00 x 17.5% or 2500.59 x 30%

Does anybody know how to do this, appreciate your responses.

The OP didn't ask for an *increase* by a percentage, but for a
*multiplication* by a percentage.

Hence =A1*17.5% or =A1*30%
--
David Biddulph

"Mike H" wrote in message
...
Try,

For 30%
=A1*1.3

For 17.5%
=A1*1.175

Mike


"jjbits4u" wrote:

I want to know how to multiply a single cell by a percentage.

ie: 2000.00 x 17.5% or 2500.59 x 30%

Does anybody know how to do this, appreciate your responses.

Does anybody know how to do this, ???

A "percentage" .... in a "single cell", you say.
Hmmmmmmmmm.
Well, I think there was someone who knew how to do that, but unfortunately
he died in 1987.
So we're all sitting here waiting for someone else to come along and work it
out.
It's a darn good question and we'll let you know if we work it out.

See ya!

Zumble.



"jjbits4u" a écrit dans le message de
news: ...
I want to know how to multiply a single cell by a percentage.

ie: 2000.00 x 17.5% or 2500.59 x 30%

Does anybody know how to do this, appreciate your responses.