IF statement help


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!


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).


Thank you so much! :smiley: