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