# rounding numbers

This is a discussion on rounding numbers within the Excel Questions forums, part of the Question Forums category; I am working on a project for my wife and I need help in correcting a formula: In (column J) ...

1. ## rounding numbers

I am working on a project for my wife and I need help in correcting a formula:

In (column J) and row 21, etc .. put these prices 24.95, 19.95, leave next three rows blank. now divid each price in half and round up and then total.
For some odd reason I am short by one cent.
put these formulas in any column but corrospending row and see what you get.
=round(L21,2)/2)
=round(L22,2)/2)
=round(L23,2)/2)
=round(L25,2)/2)

Now in column L30, I need to sum all cells, the problem is this - if the number is rounded up (for some reason the total is off by one, what is going on.

=sum(L21:L23,L25)

put these sums in each cells and add up, what do you get.

2. ## Re: rounding numbers

Hi:

Try the formula this way:

=ROUND(J21/2,2)

hope this helps

plettieri

3. ## Re: rounding numbers

You need to explain better what you are doing and what you want to do. If you want to divide by 2 and then round up, why are you rounding (*not* rounding up but just rounding) and then dividing by 2?

Also, if the numbers are entered in column J, why do the formulas refer to column L?

Finally, what are the *actual* numbers you have and the *actual* cells in which they appear -- withoug the "etc." stuff.

While I don't use it, you might want to check out Colo's HTML Maker utility. See the link at the bottom of the page.
Originally Posted by TiggerToo
I am working on a project for my wife and I need help in correcting a formula:

In (column J) and row 21, etc .. put these prices 24.95, 19.95, leave next three rows blank. now divid each price in half and round up and then total.
For some odd reason I am short by one cent.
put these formulas in any column but corrospending row and see what you get.
=round(L21,2)/2)
=round(L22,2)/2)
=round(L23,2)/2)
=round(L25,2)/2)

Now in column L30, I need to sum all cells, the problem is this - if the number is rounded up (for some reason the total is off by one, what is going on.

=sum(L21:L23,L25)

put these sums in each cells and add up, what do you get.

4. ## Re: rounding numbers

Thanks for the posting, I used the help file on my computer to help me with the rounding problem.
Walter

#### Posting Permissions

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