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?

If I am reading your post correctly you want a cell to equal C1/D1 when
A1=1
and B1= some some number
and for the cell to = "na" otherwise
=if(and(A1=1,B1=xx),C1/D1,"na")
Just enter your wanted number in place of xx or
you could put the number you want in E1 and use
=if(and(A1=1,B1=E!),C1/D1,"na")
If I am not reading your post correctly, please let me know.
in

"Flutie99" wrote:

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?

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?

=if(and(a1=1, isnumber(b1)),c1/d1,"na")
- Will

"Flutie99" wrote:

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?

thanks Michael. Another question:

Since there isn't an averageif, what is the best way to average a particular
set of numbers? Thanks.

"Michael" wrote:

Hi Flutie99
Try: =IF(A1=1,IF(ISNUMBER(B1)=TRUE,C1/D1,"na"))
--
Sincerely, Michael Colvin


"Flutie99" wrote:

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?