Help

IF statement help

1059 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Students_Workwe
4 - Data Explorer
4 - Data Explorer

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

Students_Workwe
4 - Data Explorer
4 - Data Explorer

Thank you so much! :grinning_face_with_big_eyes: