View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default multipying a cell by a percentage

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.