HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?
 

WHAT FORMULAS IS USED TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?

HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?
 

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

HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?
 

AMANDA RILEY -

If the "TOTAL NUMBER" is in cell A1, in some other cell enter

=0.002*A1

- Mike
www.mikemiddleton.com

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

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.

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.