IF formula

R

Roger

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(a>0,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
 
M

Mallycat

I think your problem may be that you have a validation rule that says
you can only have 1-9 as the entries, yet you are now trying to add a
null. You need to resolve this conflict. Maybe allowing 0-9 as the
entries and changing your null request to 0.

Matt
 
Top