How do I get XL to report the value of a cell if a (text) value in another cell is NOT true?
R Roland Mar 7, 2007 #1 How do I get XL to report the value of a cell if a (text) value in another cell is NOT true?
M Mike Mar 7, 2007 #2 In any cell will check if A1 is false and if true return the value of A2 or unspecified if false. =IF(A1=FALSE,A2,"Unspecified") Mike
In any cell will check if A1 is false and if true return the value of A2 or unspecified if false. =IF(A1=FALSE,A2,"Unspecified") Mike
