MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Make false statement = no instead


Posted by Jon Swanson on February 14, 2002 7:57 AM

I want the word no to show up instead of false on an if statement..anyone know how to do this.


Posted by Aladin Akyurek on February 14, 2002 8:06 AM

=IF(A1>10,"yes","no") and...

how about reading an elementary intro to Excel, Jon?

=======

Posted by Jon Swanson on February 14, 2002 8:22 AM

Re: =IF(A1>10,"yes","no") and...

Ouch that hurt.....this is the final one and thank you for all your help....Your answer did answer mine
=IF(K134<1000,"No",IF(K134>=1000,IF(K134>=G4,'Level 1'!F3,'Level 1'!G3)))

Posted by Aladin Akyurek on February 14, 2002 8:31 AM

Re: =IF(A1>10,"yes","no") and...

Jon --

I didn't mean to hurt you. I have the impression that you're a fast learner. An intro, I'm convinced, boost you up. By the way,you're welcome with any question that you might have.

Regards,

Aladin