Yes, well hopefully the formula worked for you as well.

Pete

On Jan 28, 2:00*pm, rajaiy wrote:
Dears

Thanks' for you helps, sorry for writing *capitals . I didn't meant what you
have describe!!



"Pete_UK" wrote:
Put this in C1:

=CEILING(B1,A1)-(MOD(B1/A1,1)<0.5)*A1

and copy down as required.

In future please do not post using only capitals - it is known as
SHOUTING, and is considered rude.

Hope this helps.

Pete

On Jan 28, 1:26 pm, rajaiy wrote:
HOH I CAN MAKE NUMBERS TO ROUNDED TO BE SUP CREPT ON THE NO IN NEXT COLUM..
E: *A1 * * * * * * *B1 * * * * * * * *C1
* * * 6 * * * * * * * *28 * * * * * *TO MAKE B1= 30
* * * 6 * * * * * * * *27 * * * * * * TO MAKE B1= 30
* * * 6 * * * * * * * *26 * * * * * * TO MAKE B1= 24
* * * 5 * * * * * * * *22 * * * * * * *TO MAKE B1=20- Hide quoted text -

- Show quoted text -