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 rajanverma1...@gmail.comwrote: 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 rajanverma1...@gmail.comwrote: *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:-) saroj.32...@gmail.comwrote: 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.comwrote: 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 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
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:-) saroj.32...@gmail.com 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 rajanverma1...@gmail.comwrote: 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 rajanverma1...@gmail.comwrote: *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:-) saroj.32...@gmail.comwrote: 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 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
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 rajanverma1...@gmail.comwrote: 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:-) saroj.32...@gmail.comwrote: 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 rajanverma1...@gmail.comwrote: 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 rajanverma1...@gmail.comwrote: *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:-) saroj.32...@gmail.comwrote: 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 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 @
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 rajanverma1...@gmail.comwrote: 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
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 noorain.ans...@gmail.comwrote: Pls try it =CONCATENATE(A1,:,B1) On Fri, May 20, 2011 at 5:08 PM, Kabir:-) saroj.32...@gmail.comwrote: 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
*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:-) saroj.32...@gmail.comwrote: 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.comwrote: 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
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 rajanverma1...@gmail.comwrote: *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:-) saroj.32...@gmail.comwrote: 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.comwrote: 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
Pls try it =CONCATENATE(A1,:,B1) On Fri, May 20, 2011 at 5:08 PM, Kabir:-) saroj.32...@gmail.com 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
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