IF Statement

[Guest]

I am trying to write an if statement that says:

=if(a=1&b=a number,c1/d1,"na")

What is the command for the "a number" part?

 

[Guest]

=IF(AND(A1=1,ISNUMBER(B1)),C1/D1,"N/A")


Regards,

Peo Sjoblom

 

[Niek Otten]

You probably mean

=IF(AND(A1=1,ISNUMBER(B1)),C1/D1,NA())

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

See your first Post.