If you want, after you are set with the second column, you can choose to hide the first one :)

Solved

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.

why do you combine columns?

I have a pretty complicated function in a cell:

=round (((B12*vanguardInterestRat

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.

6 Comments

If you want, after you are set with the second column, you can choose to hide the first one :)

If you want decimal points in the first part of the result, then don't use the Round() function

=((B12*vanguardInterestRat

If you want to break this into two cells, then use these two formulas, for example in

A1 =((B12*vanguardInterestRat

A2 =ROUND(((B12*vanguardInter

or, if you don't want to round the second part, use

A2 =((B12*vanguardInterestRat

You can then combine the two results as a text value with the & operator, using a formula like

=A1&" ("&A2&")"

Or, if you want to round the final results:

=round(A1,2)&" ("&round(A2,2)&")"

cheers, teylyn

Therefore, if you want to keep it in one column you can enclose the formula within a TEXT function and force the format of the result.

=TEXT(ROUND(((B12*vanguard

As above will apply commas and 1 decimal place.

Thanks

Rob H

=TEXT(((B12*vanguardIntere

Thanks

Rob H

12345 (405)

I wanted to say:

12,345 (405)

Teylyn:

Thank you, but I'm calculating future investment values like 40 years in the future-I don't think anything is exact enough to use lots of decimal points.

Rob H: thank you! That's the type of answer that I was trying to get.

By clicking you are agreeing to Experts Exchange's Terms of Use.

Title | # Comments | Views | Activity |
---|---|---|---|

Macro: print each sheet to pdf using ExportAsFixedFormat | 11 | 26 | |

Modify default height of drop-down filter menu in Excel | 2 | 18 | |

excel totals from one column based on 'not null cell' in a different column | 7 | 13 | |

Dynamic Bar chart in Excel | 5 | 12 |

Join the community of 500,000 technology professionals and ask your questions.

Connect with top rated Experts

**20** Experts available now in Live!