Hi Everyone,

I’m sure I have done something wrong but new to Airtable…

Trying to do a multiple IF() formula but not working… the simple formula is to generate a rental bond amount depended on two fields… the “Rent Frequency” and the “Rent on Agreement”

(The rental bond has to be equivalent to 4 weeks rent)

What I have been trying is:

IF({Rent Frequency}=“Week”,({Rent on Agreement}*4), IF({Rent Frequency}=“Fortnight”,({Rent on Agreement}*2)), IF({Rent Frequency}=“Month”,{Rent on Agreement}))

Rent Frequency is a single select dropdown for either (Week, Fortnight or Month)

Any guidance would be much appreciated

Thanks

Jason