Thread: Anyone any good on Excel?
View Single Post
Old Jun 6, 2008 | 11:02 AM
  #10  
Twellsie's Avatar
Twellsie
PassionFord Post Whore!!
iTrader: (1)
 
Joined: Mar 2005
Posts: 7,271
Likes: 9
From: Nuneaton
Default
Originally Posted by alan12112
Say F42 is the cell you want then apply this statement

=IF(F42=5,"High",IF(F42=3,"medium","low"))


spot on, cheers matey
Reply
0