View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default multipying a cell by a percentage

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.