MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Addition to Function Question

Posted by Gay Myrick on September 25, 2001 10:58 AM

Once again, thank you for the quick response to the
first function question. I have an additonal request.
(Just given to me this afternoon.)

Using the function you provided, the solution comes
up in column B1. (ie. 28025 is 17) I now need that
number to be rounded up to the nearest 10th. (ie. If
the solution is 17 in B1, then the solution in C1 needs
to be 20. All numbers over a tenth (21, 22, etc.) will
need to be 30, etc.

I do hope I have explained this properly. I've never
been that good with functions! Again, thank you for
you support.

Gay Myrick

Posted by Juan Pablo on September 25, 2001 11:08 AM

Use =CEILING(A1,10) (NT)

Posted by Aladin Akyurek on September 25, 2001 11:09 AM


In C1 enter: =CEILING(B1,10)