Forum Discussion
TimW1725
Sep 13, 2024Copper Contributor
Addition & Multiplication in one cell?
Hi,
I'm building a formula that tracks revenue as per piece counts. The table shown would need to calculate column B, while :heavy_multiplication_x: column C10
Is there a way to do this apart from a static SUM B4:B9*C10? As some routes will not use all service fields as shown in the attached photo.
Thank you.
 
3 Replies
- SergeiBaklanDiamond Contributor
- TimW1725Copper ContributorThank you Sergel That worked!😊 I was up until 1;00am trying to resolve this!! Thank you.
- SergeiBaklanDiamond Contributor
TimW1725 , you are welcome