MrExcel Publishing
Your One Stop for Excel Tips & Solutions

if 2 cells have the same value a true value is returned, if else false statement returned


Posted by Chris Jones on June 26, 2001 11:59 AM

Hey there,

I need some code that can do this.

I want a cell to display "TRUE", if 2 other cells both contain "#VALUE!". Otherwise I want a value of "FALSE" returned. If one cell says "#VALUE!" and the other cell has another value I still want it to say "FALSE"

Any help would be greatly appreciated


Posted by Aladin Akyurek on June 26, 2001 12:20 PM

Chris

I get nervous.

=IF((COUNTIF(A2,"#VALUE!")+COUNTIF(B2,"#VALUE!"))=2,TRUE,FALSE)

Aladin

Posted by Chris Jones on June 26, 2001 12:48 PM

:Aladin

Thank you, this was connected to my other problem and I have it figured out now due to your help.