Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |