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

Hi Pat

sorry don't follow you
if
=(M2+O2)/20 = 204.55
how can rounding the result to the nearest whole number equal 9

to round to 205 use
=ROUND((M2+O2)/20,0)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Pat" wrote in message
...
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

Hi Pat

sorry, figured out what you were after

does
=(CEILING((M2+O2)/20,1)-(M2+O2)/20)*20

give you what you want.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"JulieD" wrote in message
...
Hi Pat

sorry don't follow you
if
=(M2+O2)/20 = 204.55
how can rounding the result to the nearest whole number equal 9

to round to 205 use
=ROUND((M2+O2)/20,0)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Pat" wrote in message
...
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

JulieD,
That's exactly what I am looking for.
Many thanks


"JulieD" wrote in message
...
Hi Pat

sorry, figured out what you were after

does
=(CEILING((M2+O2)/20,1)-(M2+O2)/20)*20

give you what you want.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"JulieD" wrote in message
...
Hi Pat

sorry don't follow you
if
=(M2+O2)/20 = 204.55
how can rounding the result to the nearest whole number equal 9

to round to 205 use
=ROUND((M2+O2)/20,0)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Pat" wrote in message
...
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

you're welcome


"Pat" wrote in message
...
JulieD,
That's exactly what I am looking for.
Many thanks


"JulieD" wrote in message
...
Hi Pat

sorry, figured out what you were after

does
=(CEILING((M2+O2)/20,1)-(M2+O2)/20)*20

give you what you want.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"JulieD" wrote in message
...
Hi Pat

sorry don't follow you
if
=(M2+O2)/20 = 204.55
how can rounding the result to the nearest whole number equal 9

to round to 205 use
=ROUND((M2+O2)/20,0)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Pat" wrote in message
...
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