View Single Post
  #3   Report Post  
DocuMike
 
Posts: n/a
Default

No, A3 is simply a number input from the user. It can be anything greater
than 0. If A1 is FALSE I want any data in A3 to be deleted or A3 set to
blank.

"Dave O" wrote:

Does A3 contain a formula? If it does, you can use an IF() function.
Suppose the formula in A3 is =B5*B6
You could write an IF() in A3:
=IF(A1=True,B5*B6,"")