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
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
Hi Arvind
=TEXT(A1/B1,"0.00")&":1"
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"arvind3738" <[email protected]> wrote in message news:[email protected]...
| 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
What about
=ROUND(A1/B1,2)&":1"
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS
"arvind3738" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks