Why is this nested IF formula result not considered a number?

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, 
   IF({Score} = 2, 
     IF({Score} = 3, 
       IF({Score} = 4, 
         IF({Score} = 5, 

Any help is much appreciated!

With warm regards,

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.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.