Hello Airtable community.

I am trying to move my excel spreadsheets across to Airtable and would welcome any help with the Rounddown function. In Excel, it looks like this **=(ROUNDDOWN(C5,0)*6)+((C5-(ROUNDDOWN(C5,0))) 10)*

For anyone who is a cricket fan, I am looking to convert overs which consist of a max of 6 balls into total number of balls bowled. So for example, 8.4 overs = 52 balls (8 overs of 6 balls each = 48 + the 0.4 which is actually 4 balls, therefore 52.

The excel formula above works perfectly but I am struggling to convert it into an Airtable formula.

I have attached an image for ease of reference.

Any help welcome.

Best

Ladi