Help

Re: IF formula for formatting numbers in a concat

654 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jazmin_Poyser
6 - Interface Innovator
6 - Interface Innovator

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
augmented
10 - Mercury
10 - Mercury

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!