percentage?
What formulas would I use to calculate the two following problems:
1) What percentage is n$ of x? 2) What amount is y% of x? Both of these should work together - for example, if the "x" value is 100, then: 1) 25 of 100 is 25% and 2) 25 is the value of 25% of 100 I need the two separate calculations that I can use in excel -- assuming that the "x" value is constant, and the n and y values will be entered by the user. Thanks in advance! |
1)
=n/x formatted as a percentage. 2) = y% * x formatted as a number/currency, etc. In article , "r" wrote: What formulas would I use to calculate the two following problems: 1) What percentage is n$ of x? 2) What amount is y% of x? Both of these should work together - for example, if the "x" value is 100, then: 1) 25 of 100 is 25% and 2) 25 is the value of 25% of 100 I need the two separate calculations that I can use in excel -- assuming that the "x" value is constant, and the n and y values will be entered by the user. Thanks in advance! |
All times are GMT +1. The time now is 03:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com