Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide x/y should give Ratio x:y,How to express ratio in excel
Any one who knows how to show a division as ratio in excel
Divide 14953/19160 = 0.78; can be expressed as Ratio, 0.78:1 How to express the division as ratio ratio in excel. Please email this reqiuirement Urgently. Thanks & Best Regards Arvind |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide x/y should give Ratio x:y,How to express ratio in excel
Hi Arvind
=TEXT(A1/B1,"0.00")&":1" -- Kind regards, Niek Otten Microsoft MVP - Excel "arvind3738" wrote in message ... | Any one who knows how to show a division as ratio in excel | | Divide 14953/19160 = 0.78; can be expressed as Ratio, 0.78:1 | | How to express the division as ratio ratio in excel. | | Please email this reqiuirement Urgently. | | Thanks & Best Regards | Arvind |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide x/y should give Ratio x:y,How to express ratio in excel
What about
=ROUND(A1/B1,2)&":1" -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "arvind3738" wrote in message ... Any one who knows how to show a division as ratio in excel Divide 14953/19160 = 0.78; can be expressed as Ratio, 0.78:1 How to express the division as ratio ratio in excel. Please email this reqiuirement Urgently. Thanks & Best Regards Arvind |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
export excel file to outlook express contact list | New Users to Excel | |||
moving 450 active e-mail addresses from Excel to Outlook Express | Excel Discussion (Misc queries) |