Formula keeps overriding!

[andrewb9]

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

[Sho]

Hello @andrewb9,

The Formula field can be formatted for likelihood display if the output is number.