Thread: Anyone any good on Excel?
View Single Post
Old Jun 6, 2008 | 10:46 AM
  #6  
alan12112's Avatar
alan12112
Focus St mk2 310 bhp :D
 
Joined: May 2006
Posts: 2,438
Likes: 0
From: Bolton/Kirkham
Default
Say F42 is the cell you want then apply this statement

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

Reply
0