View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?

I wrote:
"AMANDA RILEY" wrote:
WHAT FORMULAS IS USED TO CALCULATE 2/10 OF
1 PERCENT OF A TOTAL NUMBER?

[....]
But why not simply write: =0.2%?


Sorry: I overlooked the latter part of you question. The
simplest answer is:

=0.2%*number

where "number" is the total number or a cell reference.