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

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

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