# Roundoff Formula

#### maheshrk81

##### Board Regular
Hi All,

I need a formula for roundoff.. If my number is less 1 (ex:0.9 0r -0.9) then it should show in decimals normally. But if it is greater then 1 (ex: 22.3 or -22.3) then it should roundoff to 22 or -22 and if it is 22.6 then it should then 23.

Regards,
Mahi

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

try this

Excel Workbook
AB
122.623
Sheet2

#### mikerickson

##### MrExcel MVP
If you just want apperance you could use the format [<=-1]-0;[<1].#;0

If you want the value to change, the formula =IF(ABS(A1)>=1, ROUND(A1,0), A1)

#### maheshrk81

##### Board Regular
I just need the appernce like -- If Greater than 1 then it should Roundoff and if it is Less then 1 then it should not roundoff. this should happen even in negtive numbers..

#### maheshrk81

##### Board Regular
I need the formula like -- If A1<1 and >-1, then A1, If not then roundoff

#### mikerickson

##### MrExcel MVP
What happened with the formula that I posted?

Replies
24
Views
219
Replies
3
Views
116
Replies
10
Views
104
Replies
3
Views
39
Replies
7
Views
299

1,127,846
Messages
5,627,235
Members
416,232
Latest member
Ash1432

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back