| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User defined functions without using VBA. | New Users to Excel | |||
| User defined functions without using VBA. | Excel Discussion (Misc queries) | |||
| User Defined Functions | Excel Worksheet Functions | |||
| User Defined Functions | Excel Worksheet Functions | |||
| User Defined Functions | Excel Worksheet Functions | |||
Threaded Mode
