Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Percentage Calculation | Excel Worksheet Functions | |||
Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
display data as a percentage of a subtotal in excel pivot table | Excel Discussion (Misc queries) | |||
percentage of sales | Excel Worksheet Functions |