# Thread: Round up if (2003)

1. ## Round up if (2003)

Hi - need to force Excel to roundup to the next whole integer if the result of a simple division formula is *.45 or higher and to round down if the result is lower. Have attached a small sample - thanks in advance - again.

Aunt Linda

2. ## Re: Round up if (2003)

Modified:
I yield to Legare's much more elegant solution. I suspect that you don't want decimal places; if so Legare's formula would be:
=ROUND(A1+.05,0)

3. ## Re: Round up if (2003)

Thank you again - and, again, works just fine.

4. ## Re: Round up if (2003)

It really does work - but I sure appreciate your response as well. It's soooooooo nice to know there are smart people out there who can help me!

Again - thanks

Aunt Linda

5. ## Re: Round up if (2003)

<img src=/S/blush.gif border=0 alt=blush width=15 height=15> OOPS, Fat fingers.

Thanks. Off to correct my post.

6. ## Re: Round up if (2003)

If the value is in A1, will this do what you want:

=ROUND(A1+.05,0)

Corrected - Thanks to Don

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•