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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,917
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,123,158
Messages
5,600,052
Members
414,357
Latest member
Gemma_R

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