ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can you change the base number from 100 to something else with %'s (https://www.excelbanter.com/excel-worksheet-functions/26900-can-you-change-base-number-100-something-else-%25s.html)

Jarod

Can you change the base number from 100 to something else with %'s
 
When calculating percentages? (I want to change it to 40)....

Gary Brown

10/40 = 25%
10/100 = 10%
HTH,
--
Gary Brown



"Jarod" wrote:

When calculating percentages? (I want to change it to 40)....


PC

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)....





All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com