Return quantity outstanding
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
|