Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Dear rajan, thanks for your help.the functions works well. Regards, Saroj. On Tue, May 24, 2011 at 5:20 PM, rajan verma wrote: > Paste this Function into your Excel VBE and then use this in Worksheet > > =Ratio2(Value1,Value2,Value3) > > > > On Tue, May 24, 2011 at 2:12 PM, Kabir:-) wrote: > >> Dear Rajan, >> >> I would be thank ful for your help. But I m not getting how exactly to run >> this VBA code in my required Excell Work Book. Can u help me...? >> >> Regards, >> >> Saroj >> >> >> On Mon, May 23, 2011 at 8:20 PM, rajan verma wrote: >> >>> Amended.. >>> >>> Function Ratio2(*ParamArray* arr()) As String >>> For i = 0 To UBound(arr) >>> Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" >>> Next >>> Ratio2 = Left(Ratio2, Len(Ratio2) - 1) >>> End Function >>> >>> On Mon, May 23, 2011 at 8:16 PM, rajan verma >>> wrote: >>> *Try this Function* Function Ratio2(*ParamArray* arr()) As String Dim Arr2(1) As Integer For i = 0 To UBound(arr) Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" Next Ratio2 = Left(Ratio2, Len(Ratio2) - 1) End Function On Mon, May 23, 2011 at 12:35 PM, Kabir:-) wrote: > Dear Rajan, > > Thanks for your formulait works. But I want to know, will there be > any macro or VBA code for the query like this. Kindly help me if anything > available like such. > > Thank you all... > > Regards, > > Saroj. > > On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma < > rajanverma1...@gmail.com> wrote: > >> Hi Kabir, >> >> See if it help. >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) >> *Sent:* Friday, May 20, 2011 5:09 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Need a formula for getting the output of >> one calculation as RATIO >> >> >> >> Dear Gurus, >> >> I need a formula for calculated two numbers and resulted output should >> be in a Ratio.i.e., 2:1 or 1.5:3. >> >> Thank you in advance, >> >> Regards, >> >> Saroj. >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Regards Rajan verma +91 9158998701 >>> >>> >>> >>> -- >>> Regards >>> Rajan verma >>> +91 9158998701 >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER fo
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Paste this Function into your Excel VBE and then use this in Worksheet =Ratio2(Value1,Value2,Value3) On Tue, May 24, 2011 at 2:12 PM, Kabir:-) wrote: > Dear Rajan, > > I would be thank ful for your help. But I m not getting how exactly to run > this VBA code in my required Excell Work Book. Can u help me...? > > Regards, > > Saroj > > > On Mon, May 23, 2011 at 8:20 PM, rajan verma wrote: > >> Amended.. >> >> Function Ratio2(*ParamArray* arr()) As String >> For i = 0 To UBound(arr) >> Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" >> Next >> Ratio2 = Left(Ratio2, Len(Ratio2) - 1) >> End Function >> >> On Mon, May 23, 2011 at 8:16 PM, rajan verma >> wrote: >> >>> *Try this Function* >>> >>> Function Ratio2(*ParamArray* arr()) As String >>> Dim Arr2(1) As Integer >>> For i = 0 To UBound(arr) >>> Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" >>> Next >>> Ratio2 = Left(Ratio2, Len(Ratio2) - 1) >>> End Function >>> >>> >>> On Mon, May 23, 2011 at 12:35 PM, Kabir:-) wrote: >>> Dear Rajan, Thanks for your formulait works. But I want to know, will there be any macro or VBA code for the query like this. Kindly help me if anything available like such. Thank you all... Regards, Saroj. On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma >>> > wrote: > Hi Kabir, > > See if it help. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) > *Sent:* Friday, May 20, 2011 5:09 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need a formula for getting the output of > one calculation as RATIO > > > > Dear Gurus, > > I need a formula for calculated two numbers and resulted output should > be in a Ratio.i.e., 2:1 or 1.5:3. > > Thank you in advance, > > Regards, > > Saroj. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel >>> >>> >>> >>> -- >>> Regards >>> Rajan verma >>> +91 9158998701 >>> >> >> >> >> -- >> Regards >> Rajan verma >> +91 9158998701 >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this g
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Dear Rajan, I would be thank ful for your help. But I m not getting how exactly to run this VBA code in my required Excell Work Book. Can u help me...? Regards, Saroj On Mon, May 23, 2011 at 8:20 PM, rajan verma wrote: > Amended.. > > Function Ratio2(*ParamArray* arr()) As String > For i = 0 To UBound(arr) > Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" > Next > Ratio2 = Left(Ratio2, Len(Ratio2) - 1) > End Function > > On Mon, May 23, 2011 at 8:16 PM, rajan verma wrote: > >> *Try this Function* >> >> Function Ratio2(*ParamArray* arr()) As String >> Dim Arr2(1) As Integer >> For i = 0 To UBound(arr) >> Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" >> Next >> Ratio2 = Left(Ratio2, Len(Ratio2) - 1) >> End Function >> >> >> On Mon, May 23, 2011 at 12:35 PM, Kabir:-) wrote: >> >>> Dear Rajan, >>> >>> Thanks for your formulait works. But I want to know, will there be >>> any macro or VBA code for the query like this. Kindly help me if anything >>> available like such. >>> >>> Thank you all... >>> >>> Regards, >>> >>> Saroj. >>> >>> On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma >>> wrote: >>> Hi Kabir, See if it help. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) *Sent:* Friday, May 20, 2011 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO Dear Gurus, I need a formula for calculated two numbers and resulted output should be in a Ratio.i.e., 2:1 or 1.5:3. Thank you in advance, Regards, Saroj. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> Regards >> Rajan verma >> +91 9158998701 >> > > > > -- > Regards > Rajan verma > +91 9158998701 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips t
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Amended.. Function Ratio2(*ParamArray* arr()) As String For i = 0 To UBound(arr) Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" Next Ratio2 = Left(Ratio2, Len(Ratio2) - 1) End Function On Mon, May 23, 2011 at 8:16 PM, rajan verma wrote: > *Try this Function* > > Function Ratio2(*ParamArray* arr()) As String > Dim Arr2(1) As Integer > For i = 0 To UBound(arr) > Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" > Next > Ratio2 = Left(Ratio2, Len(Ratio2) - 1) > End Function > > > On Mon, May 23, 2011 at 12:35 PM, Kabir:-) wrote: > >> Dear Rajan, >> >> Thanks for your formulait works. But I want to know, will there be any >> macro or VBA code for the query like this. Kindly help me if anything >> available like such. >> >> Thank you all... >> >> Regards, >> >> Saroj. >> >> On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma >> wrote: >> >>> Hi Kabir, >>> >>> See if it help. >>> >>> >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) >>> *Sent:* Friday, May 20, 2011 5:09 PM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one >>> calculation as RATIO >>> >>> >>> >>> Dear Gurus, >>> >>> I need a formula for calculated two numbers and resulted output should be >>> in a Ratio.i.e., 2:1 or 1.5:3. >>> >>> Thank you in advance, >>> >>> Regards, >>> >>> Saroj. >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Regards > Rajan verma > +91 9158998701 > -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
*Try this Function* Function Ratio2(*ParamArray* arr()) As String Dim Arr2(1) As Integer For i = 0 To UBound(arr) Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" Next Ratio2 = Left(Ratio2, Len(Ratio2) - 1) End Function On Mon, May 23, 2011 at 12:35 PM, Kabir:-) wrote: > Dear Rajan, > > Thanks for your formulait works. But I want to know, will there be any > macro or VBA code for the query like this. Kindly help me if anything > available like such. > > Thank you all... > > Regards, > > Saroj. > > On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma wrote: > >> Hi Kabir, >> >> See if it help. >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) >> *Sent:* Friday, May 20, 2011 5:09 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one >> calculation as RATIO >> >> >> >> Dear Gurus, >> >> I need a formula for calculated two numbers and resulted output should be >> in a Ratio.i.e., 2:1 or 1.5:3. >> >> Thank you in advance, >> >> Regards, >> >> Saroj. >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Dear Noorain, I will be thankful for your effort on my request. Regards, Saroj. On Fri, May 20, 2011 at 10:39 PM, NOORAIN ANSARI wrote: > Pls try it > > =CONCATENATE(A1,":",B1) > > On Fri, May 20, 2011 at 5:08 PM, Kabir:-) wrote: > >> Dear Gurus, >> >> I need a formula for calculated two numbers and resulted output should be >> in a Ratio.i.e., 2:1 or 1.5:3. >> >> Thank you in advance, >> >> Regards, >> >> Saroj. >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Thanks & regards, > Noorain Ansari > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Dear Rajan, Thanks for your formulait works. But I want to know, will there be any macro or VBA code for the query like this. Kindly help me if anything available like such. Thank you all... Regards, Saroj. On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma wrote: > Hi Kabir, > > See if it help. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) > *Sent:* Friday, May 20, 2011 5:09 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one > calculation as RATIO > > > > Dear Gurus, > > I need a formula for calculated two numbers and resulted output should be > in a Ratio.i.e., 2:1 or 1.5:3. > > Thank you in advance, > > Regards, > > Saroj. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Hi Kabir, See if it help. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kabir:-) Sent: Friday, May 20, 2011 5:09 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO Dear Gurus, I need a formula for calculated two numbers and resulted output should be in a Ratio.i.e., 2:1 or 1.5:3. Thank you in advance, Regards, Saroj. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Ratio.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO
Pls try it =CONCATENATE(A1,":",B1) On Fri, May 20, 2011 at 5:08 PM, Kabir:-) wrote: > Dear Gurus, > > I need a formula for calculated two numbers and resulted output should be > in a Ratio.i.e., 2:1 or 1.5:3. > > Thank you in advance, > > Regards, > > Saroj. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & regards, Noorain Ansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel