View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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
.

.