How do I concatenate these two fields so they show values with not so many digits. I would like to show 2 decimal digits.
Page 1 / 1
Use 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?
Click 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
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.
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
Put 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
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!
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
Could you explain the importance of maintaining consistent decimal formatting when concatenating formula fields in a spreadsheet?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.