View Single Post
  #5   Report Post  
pinmaster
 
Posts: n/a
Default How do I create a 26 'tier' IF formula?


Hi,
How about:
=CODE(LOWER(A1))-96

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=478567