Combined ROUNDUP

  • Thread starter Frustrated in AL
  • Start date
F

Frustrated in AL

Good morning, all.

I am trying to modify a formula to roundup two data sets as one roundup.
Here is how the formula is and works:

=ROUNDUP((SUM(C29/1.75)*1.15),0)+ROUNDUP(SUM(D29*0.33)*1.15,0).

Instead of rounding up both individually, I would like to round up the sum
of the two.
I have tried just removing the second ROUNDUP - error.
I have tried enclosing both operations in a new set of parenthesis - error.

Any help would be greatly appreciated.
 
P

Pete_UK

Have you tried this?:

=ROUNDUP((C29/1.75+D29*0.33)*1.15,0)

Hope this helps.

Pete
 
S

Stefi

=ROUNDUP(SUM(C29/1.75)*1.15+SUM(D29*0.33)*1.15,0)
but why do you need SUM in this formula?

Regards,
Stefi

„Frustrated in AL†ezt írta:
 
F

Frustrated in AL

Thank you Stefi. This formula was cannibalized from a previous formula that
dealt with multiple columns. As you point out, SUM is really is not required
in this instance.

Thank you for you assistance.
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

„Frustrated in AL†ezt írta:
 

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

Top