Forum Discussion

JessKDK's avatar
JessKDK
Copper Contributor
May 31, 2022

Struggling...and I'm sure it's basic...

Ok... So I have the quantity, and then the price, plus the surcharge = amount/sum. Here's what I need help with:

When there is no quantity entered, how do I get the sum cell to be a "-" (dash), but then autosum the correct amount when the quantity is entered? 

 

Ex. 

Quantity 1 x $200 + 15 = 215  ------  and then Quantity 2 x 200 + 15 + 430

 

without having to change the formula every time? Does that make sense? 

 

But when the quantity is not entered, the SUM cell is just a dash until the quantity is entered and then it knows what to multiply? (NOTE: The price + surcharge are always the same amount and entered already. Only the quantity changes, and my biggest issue is getting the SUM cell to dash when the quantity is zeroed out).