Skip to main content

Hello,

I have a number with decimal (for exemple 12.5), I want 12.90.

The field is a number field.

Exemple :

25.5 > 25.90

18 > 18.90


Thx for your help

Use this formula:


INT({Number Field}) & .9


Thx it worked but it multiplie by 10

21.4 > after the formula > 210.9

Why ?


Thx it worked but it multiplie by 10

21.4 > after the formula > 210.9

Why ?


I forgot that Airtable doesn’t like the & symbol for numbers… it will only respond properly to the + symbol.


So change it to + instead of &, and also, be sure to change the formatting of the field to decimal instead of integer.


So change the formula to this instead:


INT({Number Field}) + .9


And change the formatting of the field to decimal.


Reply