Skip to main content

Formula assistance

  • November 1, 2018
  • 1 reply
  • 19 views

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?

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+4

Hi Brad

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

Be sure to format the Percent column as a percentage.