Hi Community!

I am trying to create a formula for wind bearing and convert it to a text.

This is the formula I successfully created in Microsoft Excel and I was trying to follow a similar logic for Airtable…

=CHOOSE(1+ROUND(A2/22.5,0),“N”,“NNE”,“NE”,“ENE”,“E”,“ESE”,“SE”,“SSE”,“S”,“SSW”,“SW”,“WSW”,“W”,“WNW”,“NW”,“NNW”,“N”)

This is the formula I unsuccessfully created for Airtable.

ROUND({field1}/22.5),(“N”,“NNE”,“NE”,“ENE”,“E”,“ESE”,“SE”,“SSE”,“S”,“SSW”,“SW”,“WSW”,“W”,“WNW”,“NW”,“NNW”,“N”))

Note: {field1} is a integer field containing the wind bearing number.

Any ideas??

Thanks!