Roundup If Formula

[M Welsh]

I am looking to roundup if the number in a cell ends higher than 0.2 and round down if its lower than 0.2 so for example 1.2 would round to 2 and 1.1 would round down to 1. Have tried everything with ROUNDUP and IF but can't work it out.

Any help much appreciated

 

[Scott Huish]

Re: Help Needed with Roundup If Formula Please....

=round(a1+0.3,0)

 

[M Welsh]

Re: Help Needed with Roundup If Formula Please....

Scott Huish,

That works really well and so simple - thanks very much.

Michael