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.
|