Combined ROUNDUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=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:
 
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.
 
You are welcome! Thanks for the feedback!
Stefi

„Frustrated in AL†ezt írta:
 
Back
Top