LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default Multiple formats in a single cell with multiple formulas

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a single cell refernce to change multiple formulas BarryL Excel Worksheet Functions 5 July 12th 07 06:29 PM
Multiple dates, times, or formulas in a single cell PM-S Excel Discussion (Misc queries) 2 January 12th 06 04:19 AM
Multiple formats for a single cell value. Carlos Excel Worksheet Functions 1 October 7th 05 12:44 AM
Using a single cell in multiple formulas ebethcat Excel Worksheet Functions 1 May 26th 05 02:42 PM
How to create Multiple Conditional Formulas in a single cell? Maxfx Excel Discussion (Misc queries) 2 February 1st 05 02:26 PM


All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"