Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Ratio formula & Percentges
Hello everybody, I need a formula that will create a ratio out of two
numbers(Example: Nursing Units FTE's 90, Last month numbers 25 - Ratio 7:30) after it creates the ratios, then it turns it into a percentage (23%). Is their one formula or a combination formula out their for this. Thank you Group........ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Ratio formula & Percentges
You can format the cell as a fraction, and it will revert to the lowest
common denominator - Example: A1 = 30, B1 = 90, if C1=A1/B1 and is formatted as a fraction, it will display 1/3. So you've got your ratio expressed as a fraction (x/y) as opposed to x:y I'm not sure that's what you want, because your example doesn't make sense - 25:90 is not 7:30 - it would be 8.3:30 or 5:18 as the LCD. Six Sigma Blackbelt wrote: Hello everybody, I need a formula that will create a ratio out of two numbers(Example: Nursing Units FTE's 90, Last month numbers 25 - Ratio 7:30) after it creates the ratios, then it turns it into a percentage (23%). Is their one formula or a combination formula out their for this. Thank you Group........ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Ratio formula & Percentges
Great, thanks alot, if i go the fractional way, how do I turn that fraction
into a percentage thier after?? Thanks again "Seahawk60B" wrote: You can format the cell as a fraction, and it will revert to the lowest common denominator - Example: A1 = 30, B1 = 90, if C1=A1/B1 and is formatted as a fraction, it will display 1/3. So you've got your ratio expressed as a fraction (x/y) as opposed to x:y I'm not sure that's what you want, because your example doesn't make sense - 25:90 is not 7:30 - it would be 8.3:30 or 5:18 as the LCD. Six Sigma Blackbelt wrote: Hello everybody, I need a formula that will create a ratio out of two numbers(Example: Nursing Units FTE's 90, Last month numbers 25 - Ratio 7:30) after it creates the ratios, then it turns it into a percentage (23%). Is their one formula or a combination formula out their for this. Thank you Group........ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Ratio formula & Percentges
Great, thanks alot, if i go the fractional way, how do I turn that fraction
into a percentage thier after?? Thanks again "Seahawk60B" wrote: You can format the cell as a fraction, and it will revert to the lowest common denominator - Example: A1 = 30, B1 = 90, if C1=A1/B1 and is formatted as a fraction, it will display 1/3. So you've got your ratio expressed as a fraction (x/y) as opposed to x:y I'm not sure that's what you want, because your example doesn't make sense - 25:90 is not 7:30 - it would be 8.3:30 or 5:18 as the LCD. Six Sigma Blackbelt wrote: Hello everybody, I need a formula that will create a ratio out of two numbers(Example: Nursing Units FTE's 90, Last month numbers 25 - Ratio 7:30) after it creates the ratios, then it turns it into a percentage (23%). Is their one formula or a combination formula out their for this. Thank you Group........ |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Ratio formula & Percentges
If you've got your fraction in C1, you can put =C1 in cell D1, and format
that cell as percentage. -- David Biddulph "Six Sigma Blackbelt" wrote in message ... Great, thanks alot, if i go the fractional way, how do I turn that fraction into a percentage thier after?? Thanks again "Seahawk60B" wrote: You can format the cell as a fraction, and it will revert to the lowest common denominator - Example: A1 = 30, B1 = 90, if C1=A1/B1 and is formatted as a fraction, it will display 1/3. So you've got your ratio expressed as a fraction (x/y) as opposed to x:y I'm not sure that's what you want, because your example doesn't make sense - 25:90 is not 7:30 - it would be 8.3:30 or 5:18 as the LCD. Six Sigma Blackbelt wrote: Hello everybody, I need a formula that will create a ratio out of two numbers(Example: Nursing Units FTE's 90, Last month numbers 25 - Ratio 7:30) after it creates the ratios, then it turns it into a percentage (23%). Is their one formula or a combination formula out their for this. Thank you Group........ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Ratio formula & Percentges | Excel Discussion (Misc queries) | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
HOW CAN I PROTECT A FORMULA IN EXCEL | Excel Discussion (Misc queries) | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |