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