+2Hello,
I have been using the article "Writing nested IF statements in Airtable" as my template for assigning performance ratings based on a percentage score. This is basically exactly like the example in the article, however, I have not been successful. I cannot get "MSE", "FME", "EE", etc. to populate at all, only "DME". I tried using SWITCH as an alternative and was not having success there either. Can anybody tell what I'm doing incorrectly, and how I can remedy this problem?
+35It’s confusing because what you see onscreen for percentages isn’t what Airtable stores them as underneath the hood. What you type into a percentage field also isn’t what Airtable stores them as under the hood.
So, for your numbers in the formula:
84.9% is .849, not 84.9
90% is .90, not 90
etc.
Change the numbers and it will work.
+2It’s confusing because what you see onscreen for percentages isn’t what Airtable stores them as underneath the hood. What you type into a percentage field also isn’t what Airtable stores them as under the hood.
So, for your numbers in the formula:
84.9% is .849, not 84.9
90% is .90, not 90
etc.
Change the numbers and it will work.
Brilliant. Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.