Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a way to do that? That is, if I have a cell with several formulas
and/or added text with the use of the '&' variable, can I make each independent formula/text in the cell have a different format? Take the below example in one of my worksheet's cells. The worksheet is a statistical summary, and each of the three numbers resulting from the formulas represent a) the number of respondents that answered a certain way, b) the percentage of respondents who answered a certain way with consideration of the number of survey participants, and c) the percentage of respondents that answered a certain way on a follow-up question with consideration of the number of survey participants who answered to the affirmative on the opening question (i.e., thus making this follow-up question relevant and applicable to them). Make sense? Here is one of the cell's: =16&" ("&ROUND((16/C9)*100,2)&"%) ("&ROUND((16/30)*100,2)&"%)*" I want the first "16" in standard format, the first ROUND formula (surrounded by parenthesis) in italic format, and the second ROUND formula (surrounded by parenthises and an asterick to the right) in bold format. -- -Zakhary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a single cell refernce to change multiple formulas | Excel Worksheet Functions | |||
Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
Multiple formats for a single cell value. | Excel Worksheet Functions | |||
Using a single cell in multiple formulas | Excel Worksheet Functions | |||
How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) |