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 <[email protected]>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....:-) <[email protected]>wrote:
>
>> Dear Rajan,
>>
>> Thanks for your formula....it 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
>> <[email protected]>wrote:
>>
>>> Hi Kabir,
>>>
>>> See if it help.
>>>
>>>
>>>
>>> *From:* [email protected] [mailto:
>>> [email protected]] *On Behalf Of *Kabir....:-)
>>> *Sent:* Friday, May 20, 2011 5:09 PM
>>> *To:* [email protected]
>>> *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 [email protected]
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> 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 [email protected]
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> 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 [email protected]
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> 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 [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
