Hello! I have two fields as per this table:
Score | Likelihood |
1 | 5% |
2 | 20% |
3 | 40% |
4 | 60% |
5 | 80% |
Is it possible to type a score 1-5 in that field and return the associated percentage in the Likelihood field. Then also being able to do the reverse when needed: ie. typing in the percentage in the likelihhood field and return the associated score in the score field?
Many thanks to anyone who might be able to help me with this. It's a puzzle for me.
Andrew