Forum Discussion

TimW1725's avatar
TimW1725
Copper Contributor
Sep 13, 2024

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.

 

Resources