How do I concatenate these two fields so they show values with not so many digits. I would like to show 2 decimal digits.
Solved
Concatenate Formula Fields with 2 decimal digits
Best answer by TheTimeSavingCo
Try this:
"$" &
ROUND({Daily Fees $}, 2) &
" / " &
ROUND({Daily Fees %} * 100, 2) &
"%" 
Do note that there's also ROUNDUP() and ROUNDDOWN(), so pick whichever suits your needs!
+35Use the ROUND() function surrounding your formula like this:
ROUND(insert the text of your formula here, 2)
Use the ROUND() function surrounding your formula like this:
ROUND(insert the text of your formula here, 2)
Close, but not close enough 😉. The % is not correct and I would also like to show $ sign as well as % sign. Is that possible?
+35Click on the formatting tab to see your formatting options.
Click on the formatting tab to see your formatting options.
Yeah.. I checked already, it is not available
+35That’s because your result is not a number… it’s text. You would have to add in those symbols yourself as part of your formula.
That’s because your result is not a number… it’s text. You would have to add in those symbols yourself as part of your formula.
I have added symbols, but looks like $ sign can only go in the back which is incorrect. Not sure if there is a way to put it in the front (I have tried to fiddle around and couldn't figure it out). Also, still have the same issue with % not showing correctly with the ROUND formula
+35Put the $ sign at the very beginning of your formula.
Put the $ sign at the very beginning of your formula.
I have tried, but it is not taking the formula
+31Try this:
"$" &
ROUND({Daily Fees $}, 2) &
" / " &
ROUND({Daily Fees %} * 100, 2) &
"%"
Do note that there's also ROUNDUP() and ROUNDDOWN(), so pick whichever suits your needs!
Adam, Airtable Consultant - thetimesaving.company
Try this:
"$" &
ROUND({Daily Fees $}, 2) &
" / " &
ROUND({Daily Fees %} * 100, 2) &
"%"
Do note that there's also ROUNDUP() and ROUNDDOWN(), so pick whichever suits your needs!
Perfect... Thank you
+2Could you explain the importance of maintaining consistent decimal formatting when concatenating formula fields in a spreadsheet?
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.