Formula assistance


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?


Hi Brad

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


Be sure to format the Percent column as a percentage.