ExcelBanter - Rounding

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

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

- - Rounding (https://www.excelbanter.com/excel-worksheet-functions/73520-rounding.html)

cld5044

Rounding

I am trying to round in my spreedsheet, I have the cell rounding to 2 if it
is 1.13, my dilemma is if the cell is 9.03 it rounds to 10 and I want to know
how (if its possible) to keep it 9?

CLR

Rounding

=IF(A1-INT(A1)=0.13,ROUNDUP(A1,0),ROUND(A1,0))

Vaya con Dios,
Chuck, CABGx3

"cld5044" wrote:

I am trying to round in my spreedsheet, I have the cell rounding to 2 if it
is 1.13, my dilemma is if the cell is 9.03 it rounds to 10 and I want to know
how (if its possible) to keep it 9?

All times are GMT +1. The time now is 01:04 AM.