Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
I've created a function to calculate the volume of tanks we produce. I've limited the first imputs to bytes but I don't want to limit the last imput. However when the first two inputs, height and width, multiplied toghether are more than a byte I get an error. I don't understand why since individually the inputs are less then byte size. For eg the following produces an error Volume( 200, 100,500) Below is the function Function Volume(height As Byte, width As Byte, depth) Volume = height * width * depth End Function Any help greatly appreciated Thanks Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INEXPLICABLE FORMULA RESULT | Excel Discussion (Misc queries) | |||
File sized in inexplicable way | Excel Programming | |||
File sized in inexplicable way | Excel Programming | |||
Nested IF AND OR function Inexplicable error | Excel Worksheet Functions | |||
Inexplicable crash in VBA | Excel Programming |