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

Thanks

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


"keith" wrote:

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

Thanks

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


Replace @mailinator.com with @tiscali.co.uk


"keith" wrote in message
...
Cant figure out formula to round up if greater than ##.3 instead of ##.5
Please help.

Thanks

Thanks that worked great.

"Sandy Mann" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"keith" wrote in message
...
Cant figure out formula to round up if greater than ##.3 instead of ##.5
Please help.

Thanks

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


Replace @mailinator.com with @tiscali.co.uk


"keith" wrote in message
...
Thanks that worked great.

"Sandy Mann" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"keith" wrote in message
...
Cant figure out formula to round up if greater than ##.3 instead of
##.5
Please help.

Thanks