Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In the following calculation the result returned is correct, only I want the
quantity required to round off the result to the nearest whole number, which in this case is 9, this would then return 205 M2 = 3791 O2 = 300 =(M2+O2)/20 returns 204.55 So, instead of 204.55 being returned 9 should be displayed. Anyone know what change I can make to the formula to return this result. Thanks if you can be off help. Pat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
How do I return dynamic lists? | Excel Worksheet Functions | |||
If (either of these) return this | Excel Worksheet Functions | |||
Return lowest quantity | Excel Worksheet Functions |