# Rounding

#### Gary in Guernsey

##### New Member
Hi Team,
I have racked my brain trying to sort this, I have columns of numbers that are all integers. What i am trying to do is, if the last figure in the number is 1,2,3,or 4 then I need to set the number to round down to 0-1, so if the number is 124 i need it to be 119 and if the number ends in 6,7,8 or 9 then I need to set the number to round down to 5, so if the number is 1287 i need it to be 1285. I can either get one to work but not the other. the cell with the answer needs a formula for both cases as the column lists are vast and all change at different times.

I hope to hear from someone soon.
Kind regards
Gary

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### Momentman

##### Well-known Member
If you have individual expressions that work for both cases, then why not just use an IF statement to couple both together
Code:
``=IF(RIGHT(A1,1)+0<=4,"Do this", "Do the other")``

#### Sulprobil

##### Board Regular
Mappe1
AB
1124119
Tabelle1
Cell Formulas
RangeFormula
B1B1=FLOOR(A1,5)-(MOD(A1,10)<5)

#### Gary in Guernsey

##### New Member
Mappe1
AB
1124119
Tabelle1
Cell Formulas
RangeFormula
B1B1=FLOOR(A1,5)-(MOD(A1,10)<5)
Brilliant, thankyou very much

Replies
8
Views
107
Replies
1
Views
54
Replies
8
Views
70
Replies
27
Views
2K
Replies
5
Views
52