Roundoff Formula

[maheshrk81]

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

 

[anandvarma]

try this

Excel Workbook
	A	B
1	22.6	23
Sheet2

 

[mikerickson]

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]

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]

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

 

[mikerickson]

What happened with the formula that I posted?