View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frustrated in AL Frustrated in AL is offline
external usenet poster
 
Posts: 3
Default Combined ROUNDUP

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.