Help

Formula assistance

1233 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Brad_Walls
4 - Data Explorer
4 - Data Explorer

New to airtable

I have a rating scale (0-5) in one column, I want to turn that rating into a % and then into a decimal so I can weight that scale, I’ll give an example below:

I was given 3/5 for one of my tests, which was weighted at 25%. Ordinarily I would work it out like this:

(3/5) = 0.6

0.6*0.25 = 0.15

0.15*100 = 15%

Can anyone assist?

1 Reply 1

Hi Brad

This is quite straightforward and can be done in one formula field:

Screenshot 2018-11-01 at 15.11.06.png

17

Be sure to format the Percent column as a percentage.