Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,440
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,173
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel file with hyperlinks takes a long time to open over the network Didier P Links and Linking in Excel 3 July 4th 06 04:39 PM
Multiple Excel versions. Naveen Mukkelli Excel Discussion (Misc queries) 0 May 16th 06 12:55 AM
export excel file to outlook express contact list gebhardt family New Users to Excel 0 January 21st 05 12:59 AM
moving 450 active e-mail addresses from Excel to Outlook Express ragman10 Excel Discussion (Misc queries) 1 December 2nd 04 04:25 PM


All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"