| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ratio function
I have a series of numbers I have to convert to a ratio. Does have a
function to do this? I have tried the following formula=B26/c26 and then converting the number to (formatcellsnumbercustomgeneral). Do you have any other suggestions to my problem? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ratio function
Is the Fraction format what you're looking for?
Format/Cells/Fraction If you need more than 3 places you could use a custom format and add more ? marks. Following would show 5 digits in the numerator and denominator. # ?????/????? "Lea" wrote: I have a series of numbers I have to convert to a ratio. Does have a function to do this? I have tried the following formula=B26/c26 and then converting the number to (formatcellsnumbercustomgeneral). Do you have any other suggestions to my problem? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ratio function
One other thing, you could create a custom format and remove the leading #
sign to remove the whole number and express the entire thing as a fraction: ?????/????? "Lea" wrote: I have a series of numbers I have to convert to a ratio. Does have a function to do this? I have tried the following formula=B26/c26 and then converting the number to (formatcellsnumbercustomgeneral). Do you have any other suggestions to my problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Linear Mode
