| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you do reduce ratios in a spreadsheet
Having found the ratio between 2 numbers I need to express it in its lowest
terms. Is there a formula for doing this when one number may be odd and the other even? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you do reduce ratios in a spreadsheet
Just divide by all common factors. For example if the ratio is:
18/27 then the single common factor is 9. Dividing by 9 yields: 2/3 -- Gary''s Student - gsnu200909 "Lucy Locket" wrote: Having found the ratio between 2 numbers I need to express it in its lowest terms. Is there a formula for doing this when one number may be odd and the other even? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you do reduce ratios in a spreadsheet
=A1/GCD(A1,B1)&"/"&B1/GCD(A1,B1)
"Lucy Locket" wrote: Having found the ratio between 2 numbers I need to express it in its lowest terms. Is there a formula for doing this when one number may be odd and the other even? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ratios | Excel Worksheet Functions | |||
| ratios | Excel Discussion (Misc queries) | |||
| How to reduce all numbers in spreadsheet by a percentage | New Users to Excel | |||
| How do I reduce the number of lines in a spreadsheet? | New Users to Excel | |||
| How to Reduce Spreadsheet Size and Speed | Excel Worksheet Functions | |||
Hybrid Mode
