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")