Thread: Anyone any good on Excel?
View Single Post
Old Jun 6, 2008 | 10:54 AM
  #9  
RichardPON's Avatar
RichardPON
20K+ Super Poster.
 
Joined: May 2003
Posts: 23,377
Likes: 0
Default
I always use a adjoining cell, so you can see your reference.

Such as placing this forumla into C1

=IF(D1=5,"HIGH",IF(D1=3,"MED",IF(D1=1,"LOW","n/a")))
Reply
0