ExcelBanter - IF Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Statement (https://www.excelbanter.com/excel-discussion-misc-queries/28192-if-statement.html)

Flutie99

IF Statement

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?

Peo Sjoblom

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

Regards,

Peo Sjoblom

"Flutie99" wrote:

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?

Niek Otten

You probably mean

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Flutie99" wrote in message
...
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?

Michael

See your first Post.
--
Sincerely, Michael Colvin

"Flutie99" wrote:

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?

All times are GMT +1. The time now is 03:15 PM.