Roundup Formula

**olyneum** · 04-16-2013, 04:41 PM

I am trying to use the roundup function after a multiplication formula completes. Example: Cell D1 is formatted to percentage and the value is 45%. Cell D2 is a dollar value of $26.15. In cell D3 is the value of D1 x D2 which is $11.767. I need $11.767 to round up to $11.77 and hold that value when multiplied against another cell. Even if I format D3 for only 2 decimal places it still uses $11.767 when multiplied against another cell with 5 as a value.

How can I formulate this to roundup and hold the rounded up value?

45% x $26.15 = $11.767 Then: When I multiply $11.77 x 5 = (It should be )$58.85 but it comes out as $58.84

Clear as mud huh???

Olyneum

**Lemice** · 04-16-2013, 04:43 PM

Hello,

What you can do is to add ROUNDUP into your formula, something like this
=ROUNDUP(26.15*45/100,2)*5
Hope this help

**olyneum** · 12-10-2013, 07:30 PM

I'm back to try and make this work for me again. I had some trouble making this work in my format. Attached are the worksheets that I am working with. Hopefully it will make more sense to what I am struggling with. As you can see the totals on line 13 is what comes up with the formulas that I am using. But the totals should be what is on line 15. I think this has something to do with rounding up but I don't know how to formulate it.

Thanks
Rick

**benishiryo** · 12-10-2013, 09:21 PM

hi Rick. seems like F13 would be:
=F5*ROUND(F12,2)

**olyneum** · 12-13-2013, 06:57 PM

Thank you that works great!

Rick

**FDibbins** · 12-13-2013, 07:40 PM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.