Help

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
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.