Hi
Try this:
=IF(AND(A1=1,ISNUMBER(B1)),C1/D1,"na")

Andy.

"Flutie99" wrote in message
...
How do I write a command that says:

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

How do I write the "a number" part?