MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I get a cell to display "TRUE" based on another cell statement


Posted by Chris Jones on June 21, 2001 11:05 AM

Hey there,

How do I get a cell to display "TRUE" if another cell does not say "CPK Acc." and to display "#VALUE" if it does say "CPK Acc."

Any help here would be greatly appreciated.


Posted by IML on June 21, 2001 11:12 AM


You could use
=IF(B5="CPK ACC.","TRUE","#value")

or if you really want an error message,

=IF(B3="CPK ACC.",TRUE(),"bed"*1)

good luck

Posted by gregc on June 21, 2001 11:13 AM


=if(a1<>"CPK Acc.","TRUE","#VALUE")