Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Resouce A
16.0 = 16 big units or 96 small units 16.4 = 16 big units and 4 small units, total 100 small units I am trying to find some averages, and having troubles!. If 21 wigets cost 16.4 (100 small units), simple math tells me that each small unit = 0.21 wigets. However Excel, calculating with VBA I get 2.0999999905 - at least that is what I get when I apply result onto my worksheet. I am using: widgets / (Int(Resouce A) * 6 + (Resouce A - Int(Resouce A)) * 10) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) | |||
Worksheet rounding vs VBA rounding | Excel Programming |