Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Number end by .90

Topic Labels: Formulas
319 3
Showing results for 
Search instead for 
Did you mean: 

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

3 Replies 3

Use this formula:

INT({Number Field}) & .9

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.