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" wrote in message
...
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.