ROUNDED NUMBERS

[rajaiy]

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

 

[Niek Otten]

=MROUND(B1,A1)

If you get #NAME error:

Tools>Add-ins, check Analysis Toolpak

 

[Pete_UK]

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

 

[rajaiy]

Dears

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

 

[Pete_UK]

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

Pete