IF function Question

[drag-driver]

I want to use the IF function in this context

IF the data in cel is #value
then 1
else 2

What to do to indicate #value do

 

[Aladin Akyurek]

On 2002-04-19 03:34, drag-driver wrote:
I want to use the IF function in this context

IF the data in cel is #value
then 1
else 2

What to do to indicate #value do

=IF(ERROR.TYPE(A1)=3,1,2)