Custom Function Returns #num error

(A9) 68000
(A10) 85000
(B10) 29
(c10) =MPG(A9,A10,B10)
******************************************************
Function MPG(StartMiles As Integer, FinishMiles As Integer, Gallons As Integer)
MPG = (FinishMiles - StartMiles) / Gallons
End Function
******************************************************
Why does this return a #num error in C10?

jyellis

Integer variables are stored as 16-bit (2-byte) numbers ranging in value from -32,768 to 32,767

cells A9 & A10 are larger than 32767

Try changing Inerger to Long

Long (long integer) variables are stored as signed 32-bit (4-byte) numbers ranging in value from -2,147,483,648 to 2,147,483,647.

Thanks!!!!!

jyellis

Declare them as longs, not integers, and it should work.

hth,

Doug

"jyellis" <[email protected]> wrote in
message news:[email protected]...
>
> (A9) 68000
> (A10) 85000
> (B10) 29
> (c10) =MPG(A9,A10,B10)
> ******************************************************
> Function MPG(StartMiles As Integer, FinishMiles As Integer, Gallons As
> Integer)
> MPG = (FinishMiles - StartMiles) / Gallons
> End Function
> ******************************************************
> Why does this return a #num error in C10?
>
>
> --
> jyellis
> ------------------------------------------------------------------------
> jyellis's Profile:
> http://www.excelforum.com/member.php...o&userid=33803
> View this thread: http://www.excelforum.com/showthread...hreadid=535743
>