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

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


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553879