Roundoff Formula

maheshrk81

Board Regular
Joined
Jan 5, 2010
Messages
146
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.

Please help...

Regards,
Mahi
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,970
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
Joined
Jan 5, 2010
Messages
146
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..:(
 

Watch MrExcel Video

Forum statistics

Threads
1,127,632
Messages
5,625,994
Members
416,149
Latest member
Bigpotato 668

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top