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(C29/1.75*1.15+D29*0.33*1.15,0)


"Frustrated in AL" wrote:

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.

Have you tried this?:

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

Hope this helps.

Pete

On Oct 9, 2:35 pm, Frustrated in AL
wrote:
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:

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.

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.

"Stefi" wrote:

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

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.

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

"Stefi" wrote:

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

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.