Problem with rounding up decimal places.

**jamietttt** · 01-15-2013, 05:22 AM

Hi All, apologies if this is in the wrong section. I am having problems with my addition rounding up when I don't want it too.

If you can see the attached file - the total should come to £241.92 not £241.93. I know that it is doing this because CELL E16 and CELL E17 have 3 decimal places and its rounding them up in CELL G43. I would like it to not round these up in CELL G43. I tried the TRUNC function but no idea how to work it in CELL G43 as this has the formula to add up all the cells above it. Hope all that makes sense and thanks in advance to anyone who can help. Ss.png

**dilipandey** · 01-15-2013, 05:27 AM

Hi Jamietttt,

welcome to the forum.
working on picture is not possible, please upload a sample workbook. Thanks.

Regards,
DILIPandey
<click on below * if this helps>

**dilipandey** · 01-15-2013, 05:28 AM

Hi Jamietttt,

welcome to the forum.
working on picture is not possible, please upload a sample workbook. Thanks.

Regards,
DILIPandey
<click on below * if this helps>

**jamietttt** · 01-15-2013, 05:40 AM

Hi DILIPandey, thanks for the reply. Sample workbook uploaded, thanks!

http://ge.tt/8l6DvTV/v/0?c

**Kevin UK** · 01-15-2013, 05:45 AM

Hi jamietttt

Try in cell G16 & copy down.

Formula:

Please Login or Register  to view this content.

**Kevin UK** · 01-15-2013, 05:49 AM

Hi jamietttt

Also in G43 use : =SUM(G16:G35) instead of adding each cell!

**jamietttt** · 01-15-2013, 06:20 AM

Kevin that worked a treat, thanks again!!

**dilipandey** · 01-15-2013, 08:39 AM

Thanks Kevin for your respond as I was occupied with some other stuffs...

Jamietttt, if you issues is resolved, suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**Kevin UK** · 01-15-2013, 08:48 AM

Hi jamietttt

Thanks for the feed back.

@ dilipandey. That's OK

**jamietttt** · 01-15-2013, 11:15 AM

How do I mark it solved? Thanks

**dilipandey** · 01-15-2013, 02:57 PM

Hi jamietttt, below is what available in forum rules:-

If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

Regards,
DILIPandey
<click on below * if this helps>

Problem with rounding up decimal places.

LinkBack

Thread Tools

Rate This Thread

Display

Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Re: Problem with rounding up decimal places.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions