View Single Post
  #4   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?

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


That depends on how hard you want to make this.

The hardest answer I can think of is: put =2/10 into A1,
then put =1%*A1 into A2.

Or simply write =1%*2/10, or even =2%/10.

But why not simply write: =0.2%?

You might need to select Format Cells Percentage and
2 decimal places in order to see your answer as percentage.