what is the code that is used by excel to divide one number by another, and how this would be expressed if we were to do a UDF version?

[jco10222]

Hi, I am trying to find out what is the code that is used when software such as excel divide one number by another, and how this would be expressed as a user defined function.For example if you wanted to find A, where A = B / C. Then would the code do a do loop of C = C + C, until C > B?

 

[Andrew Poulsom]

Welcome to MrExcel.

Just use the / symbol, eg:

Function A(B, C)
    A = B / C
End Function

 

[joeu2004]

I am trying to find out what is the code that is used when software such as excel divide one number by another, and how this would be expressed as a user defined function. For example if you wanted to find A, where A = B / C. Then would the code do a do loop of C = C + C, until C > B?

I assume you mean: A = A + 1 until A*C > B.

In Excel, that is ROUNDUP(B1/C1,0) or CEILING(B1/C1,1).

In VBA, that is WorksheetFunction.RoundUp(B/C,0) or WorksheetFunction.Ceiling(B/C,1).

I don't see any reason to use a UDF since Excel functions exist. But if you insist, I would write:

Function myDiv(B As Double, C As Double) As Double
    myDiv = WorksheetFunction.RoundUp(B/C,0)
End Function

I use type Double just in case B, C or myDiv might be larger than 2,147,483,647, the max for type Long.