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.

IF formula for formatting numbers in a concat

Topic Labels: Formulas
395 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi AirTable Community,

I am trying to create an IF formula to format a number field to an abbreviated format depending on if it is 100,000 or 1,000,000… eg.

“780000” becomes “780k”
“1000000” becomes “1M”

Purpose is because I am trying to Concat the abbreviated number together with other fields.

Does anyone know how to write such a nested IF statement?

image

Thankyou in advance!!

2 Replies 2

Hi Jazmin. Give this a try…

IF((loanAmount/1000000)>1, ROUND((loanAmount/1000000),1) & 'M',
     IF((loanAmount/1000)>1, ROUND((loanAmount/1000),1) & 'k',
         loanAmount & '')
)

You can change the ROUND parameter to 0 if you don’t ever want decimal places.

Oh my gosh it works! :sob:

Thank you so much @augmented . Really appreciate it!