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