Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF formula for formatting numbers in a concat

Topic Labels: Formulas
1689 2
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!