G
Guest
WHAT FORMULAS IS USED TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike Middleton
AMANDA RILEY said:WHAT FORMULAS IS USED TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?
M
Mike Middleton
AMANDA RILEY -
If the "TOTAL NUMBER" is in cell A1, in some other cell enter
=0.002*A1
- Mike
www.mikemiddleton.com
If the "TOTAL NUMBER" is in cell A1, in some other cell enter
=0.002*A1
- Mike
www.mikemiddleton.com
G
Guest
AMANDA RILEY said: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.
G
Guest
I said:[....]AMANDA RILEY said: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.