*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
--
----------------------------------------------------------------------------------
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
