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, 
  "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.

2 Likes

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.