J_Stan - profile

J_Stan · Jul 01, 2021

Hopefully one of you amazing pros can help me resolve an issue with a nested IF Formula that isn’t quite doing what I hoped it would. I have four individual products (Line Item #1 through to Line Item #4) and if they are ‘Espresso Blend’ I’d then lik...

J_Stan · Jul 01, 2021

Chris-T: IF({Line Item #1 Coffee}=“Espresso Blend”, {Total Coffee Weight (G): Line Item #1 Quantity},0) + IF({Line Item #2 Coffee}=“Espresso Blend”, {Total Coffee Weight (G): Line Item #2 Quantity},0) + IF({Line Item #3 Coffee}=“Espresso Blend”,...

User Statistics

User Activity

Adding together numeric values based on If Formula result

Re: Adding together numeric values based on If Formula result