| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
| calculate percent met (comparing 2 date columns) | Excel Worksheet Functions | |||
| Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
| Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
| Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
Hybrid Mode
