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?
Thankyou in advance!!