Rounding up @ 3 instead of 5

[keith]

Cant figure out formula to round up if greater than ##.3 instead of ##.5
Please help.

Thanks

 

[Teethless mama]

=INT(A1)+(MOD(A1,1)>=0.3)

 

[Sandy Mann]

Won't simply:

=ROUND(A1+0.2,0)

do what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk

 

[keith]

Thanks that worked great.

Won't simply:

=ROUND(A1+0.2,0)

do what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

Glad to help. Thanks for taking the time to post back.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk