Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
Solved
Jump to Solution
291 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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.

See Solution in Thread

2 Replies 2

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.