IF statement help


#1

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

Untitled

thank you!


#2

I think it is: IF({Stipend Type} = "Half", 5, 10) * {June Total Days}

47

You do the IF check and then the multiplication (as you said).


#3

Thank you so much! :smiley: