to make this simple a1 has a value that can change, b1 has the formula to test a1 value. c1 is reset to a chosen value based on a1.
I have a table that people can input values. I have a list box in a1 which they can choose 'reset'. I want the table values to change to 0 , to 'clear' the table so people can then input new values.
I was trying to test this with a single cell as stated as above. The formula I put into b1
this isn't changing c1 value but is including the c1=0 into the test part of the if then.
trouble is we are not allowed to use Macros or vb code because where this is stored so I am forced to use formulas.
was this clear enough?