User Defined Functions
Thanks Peter! It worked great and now I can move on!!!!
-----Original Message-----
Hello
You can use the worksheet roundup function in a UDF. See
below.
Function SPrice(Weight As Double, MatCost As Double) As
Double
SPrice = Application.WorksheetFunction.RoundUp(Weight
*
MatCost, 0)
End Function
Regards
Peter
-----Original Message-----
I have a function that can increase the price of an
item
based on it's weight and current cost of material. I
now
need to add a "RoundUp" portion to the function. Can I
use a function "inside" another one?????
TIA
.
.
|