thank you Noorain ji !!
On Fri, Jul 20, 2012 at 8:45 AM, NOORAIN ANSARI wrote:
> Hi Sunita,
>
> Try this one
>
> *=SUBSTITUTE(TEXT(A1/B1,"?/?"),"/",":")*
> or
>
> *=ROUND(A1/B1, 2) &":" & ROUND(B1/A1,2)*
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelvbaclinic.
Hi Sunita,
Try this one
*=SUBSTITUTE(TEXT(A1/B1,"?/?"),"/",":")*
or
*=ROUND(A1/B1, 2) &":" & ROUND(B1/A1,2)*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com
On Thu, Jul 19, 2012 at 3:08 PM, सुनिता पौडेल wrote:
> it shows 1:0
>
> thnx
>
> On Thu, J
it shows 1:0
thnx
On Thu, Jul 19, 2012 at 2:57 PM, NOORAIN ANSARI wrote:
> Please try it..
>
> Hope it will help to you.
> =(LEFT(TEXT(A1/B1,"/"),FIND("/",TEXT(A1/B1,"/"))-1)&":"
> &RIGHT(TEXT(A1/B1,"/"),LEN(TEXT(A1/B1,"/"))
> -FIND("/",TEXT(A1/B1,"/"
Please try it..
Hope it will help to you.
=(LEFT(TEXT(A1/B1,"/"),FIND("/",TEXT(A1/B1,"/"))-1)&":"
&RIGHT(TEXT(A1/B1,"/"),LEN(TEXT(A1/B1,"/"))
-FIND("/",TEXT(A1/B1,"/"
On Thu, Jul 19, 2012 at 2:07 PM, सुनिता पौडेल wrote:
> not working .is it becaus
not working .is it because add-ins blah..
thnx
On Thu, Jul 19, 2012 at 1:58 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:
> http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/*
> ***
>
> ** **
>
> ** **
>
> Regards,
>
> ** **
>
> Krish
http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/
Regards,
Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboar
Hi Sunita
Please try it
=E7/GCD(E7,F7) &":" & F7/GCD(E7,F7)
On Thu, Jul 19, 2012 at 1:34 PM, सुनिता पौडेल wrote:
> Dear all,
>
> Please do me one favor. I tried to find out the ratio between two numbers
> but seems the formula isn't working. So can you please help me.
>
> Thank you
>
> Sunita
>
