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. |
Combined ROUNDUP
=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. |
Combined ROUNDUP
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. |
Combined ROUNDUP
=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. |
Combined ROUNDUP
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. |
Combined ROUNDUP
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. |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com