Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating ratios: Is there a formula that can do this?
Is there a formula that will allow for a return value as a ratio, i.e. 2:1,
4:1 and so forth? This would be a great analytical tool. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating ratios: Is there a formula that can do this?
Try =A1/GCD(A1,B1)&":"&B1/GCD(A1,B1)
But that would be text and hence one would not be able to use the cell to do further arithmetic. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "dshadrock" wrote in message ... Is there a formula that will allow for a return value as a ratio, i.e. 2:1, 4:1 and so forth? This would be a great analytical tool. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating ratios: Is there a formula that can do this?
Hi,
You could use a fraction format, fractions are ratios. For example the following custom format (Format, Cells, Number tab, Custom and enter code on the Type line) ?.0":"1 would display 2.5 as 2.5:1 And the number can still be used as a number in calculations -- If this helps, please click the Yes button Cheers, Shane Devenshire "dshadrock" wrote: Is there a formula that will allow for a return value as a ratio, i.e. 2:1, 4:1 and so forth? This would be a great analytical tool. -- If this helps, please click the Yes button Cheers, Shane Devenshire "dshadrock" wrote: Is there a formula that will allow for a return value as a ratio, i.e. 2:1, 4:1 and so forth? This would be a great analytical tool. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ratios | Excel Worksheet Functions | |||
ratios | Excel Discussion (Misc queries) | |||
I need help with ratios | Excel Discussion (Misc queries) | |||
Ratios | Excel Discussion (Misc queries) | |||
Formula for Ratios | Excel Worksheet Functions |