Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about rounding.
I have learned how to work with Excel completely on my own with no books or
anything, so I don't know the correct verbage to ask my question. Basically it is this. Cell D41 = J41*1.3. Cell D41 is formatted for no decimal places. I need cell D41 to be rounded up to the next 99. (say the value of J41*1.3=2209, I need the value to be 2299) I am sure this is a simple and stupid question, but I have been trying to do this myself for hours. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about rounding.
Just round up to the nearest 100 and then subtract 1... something like this...
=ROUNDUP(J41*1.3, -2) - 1 -- HTH... Jim Thomlinson "Gsotoolman" wrote: I have learned how to work with Excel completely on my own with no books or anything, so I don't know the correct verbage to ask my question. Basically it is this. Cell D41 = J41*1.3. Cell D41 is formatted for no decimal places. I need cell D41 to be rounded up to the next 99. (say the value of J41*1.3=2209, I need the value to be 2299) I am sure this is a simple and stupid question, but I have been trying to do this myself for hours. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about rounding.
Brilliant! Thanks so much. Sad that such a simple problem should keep me
baffled for hours! Again, thank you. "JMB" wrote: Try: =CEILING(J41*1.3+1,100)-1 "Gsotoolman" wrote: I have learned how to work with Excel completely on my own with no books or anything, so I don't know the correct verbage to ask my question. Basically it is this. Cell D41 = J41*1.3. Cell D41 is formatted for no decimal places. I need cell D41 to be rounded up to the next 99. (say the value of J41*1.3=2209, I need the value to be 2299) I am sure this is a simple and stupid question, but I have been trying to do this myself for hours. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about rounding.
Unless J41*1.3 = 2200, then you will round down to 2199 instead of up to 2299.
"Jim Thomlinson" wrote: Just round up to the nearest 100 and then subtract 1... something like this... =ROUNDUP(J41*1.3, -2) - 1 -- HTH... Jim Thomlinson "Gsotoolman" wrote: I have learned how to work with Excel completely on my own with no books or anything, so I don't know the correct verbage to ask my question. Basically it is this. Cell D41 = J41*1.3. Cell D41 is formatted for no decimal places. I need cell D41 to be rounded up to the next 99. (say the value of J41*1.3=2209, I need the value to be 2299) I am sure this is a simple and stupid question, but I have been trying to do this myself for hours. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about rounding.
You're quite welcome. Thanks for the feedback!
"Gsotoolman" wrote: Brilliant! Thanks so much. Sad that such a simple problem should keep me baffled for hours! Again, thank you. "JMB" wrote: Try: =CEILING(J41*1.3+1,100)-1 "Gsotoolman" wrote: I have learned how to work with Excel completely on my own with no books or anything, so I don't know the correct verbage to ask my question. Basically it is this. Cell D41 = J41*1.3. Cell D41 is formatted for no decimal places. I need cell D41 to be rounded up to the next 99. (say the value of J41*1.3=2209, I need the value to be 2299) I am sure this is a simple and stupid question, but I have been trying to do this myself for hours. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about rounding.
What is the +1 for... Try that with 460.77 and you get a possible mistake...
460.77 * 1.3 = 599.001 Your formula returns 699. A a guess you would want 599 as .001 is only 1 tenth of a cent over 599... -- HTH... Jim Thomlinson "Gsotoolman" wrote: I have learned how to work with Excel completely on my own with no books or anything, so I don't know the correct verbage to ask my question. Basically it is this. Cell D41 = J41*1.3. Cell D41 is formatted for no decimal places. I need cell D41 to be rounded up to the next 99. (say the value of J41*1.3=2209, I need the value to be 2299) I am sure this is a simple and stupid question, but I have been trying to do this myself for hours. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about rounding.
It depends what the op wants. You have assumed that there should be 2
roundings. First decimals should be rounded up to the nearest whole number (done by adding 1 to target * 1.3) and then that number should be rounded up to the nearest 100. I have assumed only 1 rounding should occure and that is the target * 1.3 Your way 460.77 * 1.3 = 599.001 599.001 + 1 = 600.001 600.001 round up to nearest 100 = 700 700 - 1 = 699 My way 460.77 * 1.3 = 599.001 599.001 round up to nearest 100 = 600 600 - 1 = 599 -- HTH... Jim Thomlinson "JMB" wrote: Unless J41*1.3 = 2200, then you will round down to 2199 instead of up to 2299. "Jim Thomlinson" wrote: Just round up to the nearest 100 and then subtract 1... something like this... =ROUNDUP(J41*1.3, -2) - 1 -- HTH... Jim Thomlinson "Gsotoolman" wrote: I have learned how to work with Excel completely on my own with no books or anything, so I don't know the correct verbage to ask my question. Basically it is this. Cell D41 = J41*1.3. Cell D41 is formatted for no decimal places. I need cell D41 to be rounded up to the next 99. (say the value of J41*1.3=2209, I need the value to be 2299) I am sure this is a simple and stupid question, but I have been trying to do this myself for hours. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about rounding.
I see now the OP only said D41 was formatted not to show decimals, not that
the actual value was rounded to no decimals. So, my example is flawed. However, the OP said he wanted to round up to the next ##99, so I would still think 599.001 s/b rounded to 699. But, what I *think* he wants is irrelevant - I'll leave it to him to decide what to do in this case. "Jim Thomlinson" wrote: What is the +1 for... Try that with 460.77 and you get a possible mistake... 460.77 * 1.3 = 599.001 Your formula returns 699. A a guess you would want 599 as .001 is only 1 tenth of a cent over 599... -- HTH... Jim Thomlinson "Gsotoolman" wrote: I have learned how to work with Excel completely on my own with no books or anything, so I don't know the correct verbage to ask my question. Basically it is this. Cell D41 = J41*1.3. Cell D41 is formatted for no decimal places. I need cell D41 to be rounded up to the next 99. (say the value of J41*1.3=2209, I need the value to be 2299) I am sure this is a simple and stupid question, but I have been trying to do this myself for hours. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding Up question | Excel Worksheet Functions | |||
Rounding Question | Excel Worksheet Functions | |||
Rounding Question | Excel Worksheet Functions | |||
Rounding Question | Excel Discussion (Misc queries) | |||
rounding question | Excel Discussion (Misc queries) |