This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Re: IF statment from Excel to Airtable

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

0
1397
0

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 10, 2023 01:51 PM

Hello Formula Gurus-

I am trying to convert some excel formulas to airtable and struggling a bit. This is the formula in excel:

=IF(J2>=8.5,"A",IF(J2>=7.5,"A-",IF(J2>=6.5,"B+",IF(J2>=5.5,"B",IF(J2>=4.5,"B-",IF(J2>=3.5,"C+",IF(J2>=2.5,"C",IF(J2>=1.5,"D",IF(J2>=1,"F")))))))))

Any help is appreciated! thank you

7 Replies 7

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 10, 2023 03:08 PM - edited May 15, 2023 01:15 PM

Your formula is fine for airtable. You just need to relace the cell identitation 'J2' with the name of the field that has the information for your formula. For instance if your field was named 'Points' it would read:

IF({Points}>=8.5,'A',

IF({Points}>=7.5,'A-',

IF({Points}>=6.5,'B+',

IF({Points}>=5.5,'B',

IF({Points}>=4.5,'B-',

IF({Points}>=3.5,'C+',

IF({Points}>=2.5,'C',

IF({Points}>=1.5,'D',

IF({Points}>=1,'F'

)

)

)

)

)

)

)

)

)

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 15, 2023 01:10 PM

I must had been off a parenthesis or somehting, because I got an error earlier. THank you!

**BUT**...now I am being asked for something slightly different.

We want to grade one department under the rubic above and all others under a different rubic

If deparment = {piano} (rubic above)

departments not equal to Piano (slighlty different rubic)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 15, 2023 01:32 PM

I would likly do this by adding in the switch function. For this I woudl create a field call 'Rubric' which Swtich() evalauted as being one or another condition. In the example below I use the term 'Piano' or 'Instrumemental' as single select options in the 'Rubric' field. The nice thing about switch is that if they keep adding new ideas you can just add the new condition rather easily with a new points/grade breakdown.

SWITCH({Rubric}, 'Piano',

IF({Points}>=8.5,'A',

IF({Points}>=7.5,'A-',

IF({Points}>=6.5,'B+',

IF({Points}>=5.5,'B',

IF({Points}>=4.5,'B-',

IF({Points}>=3.5,'C+',

IF({Points}>=2.5,'C',

IF({Points}>=1.5,'D',

IF({Points}>=1,'F'

)

)

)

)

)

)

)

)

)

, 'Instrumental',

IF({Points}>=8,'A',

IF({Points}>=7,'A-',

IF({Points}>=6,'B+',

IF({Points}>=5,'B',

IF({Points}>=4,'B-',

IF({Points}>=3,'C+',

IF({Points}>=2,'C',

IF({Points}>=1,'D',

IF({Points}>=.5,'F'

)

)

)

)

)

)

)

)

)

)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 17, 2023 01:59 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 17, 2023 03:20 PM - edited May 17, 2023 03:21 PM

Sorry you are having trouble @CPMSM

I'm not really sure why you might be getting an error. I tested the formula in my test base before I sent it to you. Here is a link to it working. Perhaps that might help. I remember getting a error at one point when I first wrote it and but the fix seemed simple at the time and I can't replicate it anymore. https://airtable.com/shrmgwhgXo1GAgAxT

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 17, 2023 04:49 PM

This is outside my wheelhouse, so I appreciate all your help. 🙂

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 17, 2023 04:53 PM

Anytime!!