Keep IF formula but be able to change quantity if value is true

[me231011]

Hi,

I have a cell that has an IF formula and a Form Control linked to it. If I click the up arrow, the cell input goes up one increment however the IF formula is removed.

How do I keep the rule in place but be able to manually enter quantity if value is true?

OR

Can I get the Form Control to do this "3,2,1, blank cell" instead of "3,2,1,0"?

See attached images and notice how the formula changes in cell C17 after I click the up arrow for the form control

 

[GraH]

Would this be okay?
Keep Form control 3->0, and format cell as 0,0,"" (third position is zero value and you would "show" "" )