| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format a ratio
I am using the following formula to calculate a ratio but the problem that I
am running into is that the final answer turns out to be 1:20.665478 and I need to format it to be 1:21. =(C5/GCD(C5)&":"&C5/GCD(C3)) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a ratio
=(C5/GCD(C5)&":"&ROUND(C5/GCD(C3),0))
-- Gary''s Student - gsnu200778 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a ratio
I'm not sure what the GCD()'s are doing in your formula, but maybe...
="1:"&TEXT(C5/C3,"##") If it doesn't help, how about sharing what's in C5 and C3? USD305 wrote: I am using the following formula to calculate a ratio but the problem that I am running into is that the final answer turns out to be 1:20.665478 and I need to format it to be 1:21. =(C5/GCD(C5)&":"&C5/GCD(C3)) -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a ratio
what I am trying to do is get a ratio using the following example: I have 3
departments with a total of 74 employees. so the final ratio I am lookin for is 1:25 not 1:24.67. So C5 is employees and C3 is departments/managers "Dave Peterson" wrote: I'm not sure what the GCD()'s are doing in your formula, but maybe... ="1:"&TEXT(C5/C3,"##") If it doesn't help, how about sharing what's in C5 and C3? USD305 wrote: I am using the following formula to calculate a ratio but the problem that I am running into is that the final answer turns out to be 1:20.665478 and I need to format it to be 1:21. =(C5/GCD(C5)&":"&C5/GCD(C3)) -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a ratio
So did the suggested formula work?
USD305 wrote: what I am trying to do is get a ratio using the following example: I have 3 departments with a total of 74 employees. so the final ratio I am lookin for is 1:25 not 1:24.67. So C5 is employees and C3 is departments/managers "Dave Peterson" wrote: I'm not sure what the GCD()'s are doing in your formula, but maybe... ="1:"&TEXT(C5/C3,"##") If it doesn't help, how about sharing what's in C5 and C3? USD305 wrote: I am using the following formula to calculate a ratio but the problem that I am running into is that the final answer turns out to be 1:20.665478 and I need to format it to be 1:21. =(C5/GCD(C5)&":"&C5/GCD(C3)) -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format a ratio
Thank you for getting me up and going!
"USD305" wrote: I am using the following formula to calculate a ratio but the problem that I am running into is that the final answer turns out to be 1:20.665478 and I need to format it to be 1:21. =(C5/GCD(C5)&":"&C5/GCD(C3)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I format an Excel sheet to create a ratio as in 1:25 ?? | Excel Discussion (Misc queries) | |||
| Ratio | Excel Discussion (Misc queries) | |||
| Divide x/y should give Ratio x:y,How to express ratio in excel | Excel Worksheet Functions | |||
| RATIO number format | Excel Worksheet Functions | |||
| How do I calculate and display ratio ( format 3.5:2) | Excel Worksheet Functions | |||
Hybrid Mode
