| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can you change the base number from 100 to something else with %'s
When calculating percentages? (I want to change it to 40)....
|
|
#2
|
|||
|
|||
|
10/40 = 25%
10/100 = 10% HTH, -- Gary Brown "Jarod" wrote: When calculating percentages? (I want to change it to 40).... |
|
#3
|
|||
|
|||
|
Technically this answer is incorrect. Though it probably provides what the
OP was requesting. From a technical standpoint the base of a percent is by definition 100. (Cent=100) Using your examples 10/40 = 25% means 25 per hundred not per forty If the base were 40 then the "perforty" would be 10. PC "Gary Brown" wrote in message ... 10/40 = 25% 10/100 = 10% HTH, -- Gary Brown "Jarod" wrote: When calculating percentages? (I want to change it to 40).... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions | |||
| Base number functions, example DEC2BIN | Setting up and Configuration of Excel | |||
| How do I change z-axis value from zero to a higher number (eg 4)? | Charts and Charting in Excel | |||
| EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
Hybrid Mode
