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