Returning formatted output from a User defined function

Hi,
I need a user defined function to return formatted output

function userdefined(arg1, arg2) as double
userdefined = arg1/arg2
end function

I want the output as a percentage. Pls let me know the statement for that.
Thanks.

UDF's can not modify formats. A function called from within Code can act upon
any cells to change formats and whatever else that they want. When called
from a sheet however UDF's can ONLY return values to the cell that they are
in. They can not modify the values of cells that they are not in and they can
not modify the format of any cells. Just one of those rules...
--
HTH...

Jim Thomlinson


"Salman" wrote:

> Hi,
> I need a user defined function to return formatted output
>
> function userdefined(arg1, arg2) as double
> userdefined = arg1/arg2
> end function
>
> I want the output as a percentage. Pls let me know the statement for that.
> Thanks.

Bonsoir Salman « Salem »

si j'ai bien compris voilÃ* ce que tu cherchais

Function userdefined(arg1, arg2)
Application.Volatile
userdefined = FormatPercent(arg1 / arg2, 0)
End Function

Abed_H


"Salman" a écrit :

> Hi,
> I need a user defined function to return formatted output
>
> function userdefined(arg1, arg2) as double
> userdefined = arg1/arg2
> end function
>
> I want the output as a percentage. Pls let me know the statement for that.
> Thanks.

You mean ?

function userdefined(arg1, arg2) as double
userdefined = arg1/arg2 * 100
end function

NickHK

"Salman" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I need a user defined function to return formatted output
>
> function userdefined(arg1, arg2) as double
> userdefined = arg1/arg2
> end function
>
> I want the output as a percentage. Pls let me know the statement for that.
> Thanks.