If formulas need to have an else statement. If you write a VBA statement you can skip the Else statement but the complication goes up and you will want to get ready to learn.
I think you can accomplish what you need with a formula.
The formula that I would use if it were me would be
=if(B1=1,C1,"")
This will keep the formula cell blank unless the condition is met.
|