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