Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Help with Grade Formula

Topic Labels: Formulas
660 3
Showing results for 
Search instead for 
Did you mean: 

I am putting together a base for some schoolwork. I have a field for Points possible and points earned. Then I have a formula field with the following formula to calculate the grade percentage (Earned/Points*100) displayed as an integer. My problem is that not all assignments are graded so the ones that are not come up with NaN. Is there any workaround that would just leave it blank or 0. Thanks for any help you can offer.

3 Replies 3

Adjust your formula like so:

IF({Points Earned}, ({Points Earned}/{Points Possible}*100), 0)

If you want the field to be blank, remove the “,0” from the formula above.

It does not seem to be working. I have the following based on the actual field names IF(Earned), (Earned/Points*100), 0). The ones i used above was an example of what i was trying to do.

Nevermind, I figured it out. Thanks so much