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.