ExcelBanter - ROUNDED NUMBERS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ROUNDED NUMBERS (https://www.excelbanter.com/excel-worksheet-functions/218170-rounded-numbers.html)

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

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

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 -