In a column, I have validation set for column B with minimum value as 1 and
maximum value as 9. In the same column, I want the IF formula where true
should result in 1 while false should result in null. e.g. for column B,
if(a0,1,__). In the blank, "" is not working. What should I put so that no
value is updated if the result is false?

Thanks for your help in advance.

Roger