Skip to main content

Hey Airtable community,


Here’s my formula. The formula itself works, but I want to format the output as a currency. Why is Airtable saying it’s not a number?


IF({Score} = 1, 

  "75",

   IF({Score} = 2, 

     "120",

     IF({Score} = 3, 

       "180",

       IF({Score} = 4, 

         "240",

         IF({Score} = 5, 

           "225"

         )

       )

     )

   )

)

Any help is much appreciated!


With warm regards,

Alex

When you put your numbers in quotation marks, that tells Airtable that it is a string of text. So, you’ll want to remove the quotation marks from your numbers.

When you put your numbers in quotation marks, that tells Airtable that it is a string of text. So, you’ll want to remove the quotation marks from your numbers.


Silly me. Thanks so much, Scott! Solved.

Reply


Terms & Conditions