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