Thread: If functions with Text << Response to Karen
View Single Post
  #1   Report Post  
SUB-ZERO
 
Posts: n/a
Default If functions with Text << Response to Karen
Hi Karen,

Try this ...

=IF(A1="YNNNYYNN","ClassA",IF(A1="NNYYYNNN","Class B",IF(A1="NNNNNNNY","ClassB","")))

SUB-ZERO


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

Reply With QuoteReply With Quote