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
