ExcelBanter - Using IF command

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

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

- - Using IF command (https://www.excelbanter.com/excel-discussion-misc-queries/109359-using-if-command.html)

Arain

Using IF command

I have columns to compare. if column c has "#N/A" and D has"" and E has
"#N/A" then the the value to column B should return configured. can some one
help with the formula

Allllen

Using IF command

=IF(AND(ISNA(C1),D1="",ISNA(E1)),"configured","not configured")
(in cell B1)
--
Allllen

"Arain" wrote:

I have columns to compare. if column c has "#N/A" and D has"" and E has
"#N/A" then the the value to column B should return configured. can some one
help with the formula

Arain

Using IF command

Correction i made a mistake in my post if column c has "#N/A" and D has"" and
E has
"#N/A" then the the value to column B should return not configured. can
some one
help with the formula

"Allllen" wrote:

=IF(AND(ISNA(C1),D1="",ISNA(E1)),"configured","not configured")
(in cell B1)
--
Allllen

"Arain" wrote:

I have columns to compare. if column c has "#N/A" and D has"" and E has
"#N/A" then the the value to column B should return configured. can some one
help with the formula

Allllen

Using IF command

=IF(AND(ISNA(C1),D1="",ISNA(E1)),"not configured","configured")
(in cell B1)
--
Allllen

"Arain" wrote:

Correction i made a mistake in my post if column c has "#N/A" and D has"" and
E has "#N/A" then the the value to column B should return not configured. can
some one
help with the formula

"Allllen" wrote:

=IF(AND(ISNA(C1),D1="",ISNA(E1)),"configured","not configured")
(in cell B1)
--
Allllen

"Arain" wrote:

I have columns to compare. if column c has "#N/A" and D has"" and E has
"#N/A" then the the value to column B should return configured. can some one
help with the formula

All times are GMT +1. The time now is 09:48 PM.