Combined ROUNDUP

[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.

 

[Guest]

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

 

[Pete_UK]

Have you tried this?:

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

Hope this helps.

Pete

 

[Guest]

=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:

 

[Guest]

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.

 

[Guest]

You are welcome! Thanks for the feedback!
Stefi

„Frustrated in AL†ezt írta: