User Defined Functions

  • Thread starter Thread starter KMcNelson
  • Start date Start date
K

KMcNelson

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
 
-----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
.
Yes, you certainly can.. I have done it many times..
Click to expand...
 
Are we talking Excel or VBA. If Excel, that is not a problem, For instance

=IF(A1>0, ROUNDUP(A1,0), B1)

Similarly, in VBA, it could be

Function abc(rng As Range)

If rng(1, 1).Value > 0 Then
abc = WorksheetFunction.RoundUp(rng, 0)
Else
abc = rng.Offset(0, 1).Value
End If

End Function

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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
 
Back
Top