Why do you combine columns and Excel?
Posted on 2012-09-17
I am actually using the Google document, spreadsheet, but it seems to copy the Excel spreadsheet pretty closely. My question is:
why do you combine columns?
I have a pretty complicated function in a cell:
=round (((B12*vanguardInterestRate)/12), 0) & " (" & round (((B12 *vanguardInterestRate)/365.25), 2) & ")"
This just prints the monthly interest value of an account and the daily interest value of the account enclosed in parentheses. I would like the monthly interest value to have commas in it to make the amount more understandable. Instead of doing it the above way, should I break this into 2 columns for formatting purposes, and then combine them after I have formatted the cells? "VanguardInterestRate" is just a named cell to make the formula more understandable. "B12" is an amount of money.