Rounding up @ 3 instead of 5

K

keith

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

Thanks
 
S

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
K

keith

Thanks that worked great.

Sandy Mann said:
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
S

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
Formula help 2
rounding up to the nearest 1000 1
Divide a # into 3 #'s rounded to a whole # 9
Rounding Time to Nearest 5 Minutes 1
Round Function 5
How to refer to a criterie in a cell using excel sum.if function 3
Round up to next .5 5

Top