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

  • Thread starter Thread starter Guest
  • Start date Start date
AMANDA RILEY said:
WHAT FORMULAS IS USED TO CALCULATE 2/10 OF
1 PERCENT OF A TOTAL NUMBER?
Click to expand...

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.
 
I said:
AMANDA RILEY said:
WHAT FORMULAS IS USED TO CALCULATE 2/10 OF
1 PERCENT OF A TOTAL NUMBER?
Click to expand...
[....]
But why not simply write: =0.2%?
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Future Value 6
Scrabble Value calculation for Welsh words 0
Calculating weighted average of Percent Change 0
How to Populate Data from a table to another 0
percent rank 1
calculated field in pivot - how to edit 3
Curve fitting with weighted trendline 1
Percentage 4

Back
Top