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


I get nervous.



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


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