Jun 04, 2018 01:33 AM
Hi there,
I’m trying to write an If statement that will check what the stipend type is and then if it is half or full will multiply the total number of days by a number.
I’ve written this but this doesn’t seem to work and I don’t have a lot of experience using Airtable.
If stipend type = half then June total days * 5 else June total days * 10
thank you!
Jun 04, 2018 03:03 AM
I think it is: IF({Stipend Type} = "Half", 5, 10) * {June Total Days}
You do the IF check and then the multiplication (as you said).
Jun 13, 2018 03:01 AM
Thank you so much! :grinning_face_with_big_eyes: