# Placing Text within a formula in MS Excel

I have the following formula...

=IF(AND(\$M\$11="X",\$O\$11="",\$Q\$11=""),IF(\$T\$11="X","Normalized Earnings Before Interest and Taxes ","Unadjusted Earnings Before Interest and Taxes ")&\$M\$10,IF(AND(\$M\$11="",\$O\$11="X",\$Q\$11=""),IF(\$T\$11="X","Normalize ","Unadjusted ")&\$O\$10,IF(AND(\$M\$11="",\$O\$11="",\$Q\$11="X")," "&\$Q\$12," EBIT, EBITDA or Other Method")))

when \$T\$11 contains an "X", the cell returns
Normalized Earnings Before Interest and Taxes EBIT <====(the EBIT comes from cell \$M\$10)
I want to put the term EBIT in parenthesis
Microsoft Excel

Last Comment
Bill Golden
Missus Miss_Sellaneus

=SUBSTITUTE(IF(AND(\$M\$11="X",\$O\$11="",\$Q\$11=""),IF(\$T\$11="X","Normalized Earnings Before Interest and Taxes ","Unadjusted Earnings Before Interest and Taxes ")&\$M\$10,IF(AND(\$M\$11="",\$O\$11="X",\$Q\$11=""),IF(\$T\$11="X","Normalize ","Unadjusted ")&\$O\$10,IF(AND(\$M\$11="",\$O\$11="",\$Q\$11="X")," "&\$Q\$12," EBIT, EBITDA or Other Method"))),"EBIT","(EBIT)")
You can simply do this to get what you are looking for...

=IF(AND(\$M\$11="X",\$O\$11="",\$Q\$11=""),IF(\$T\$11="X","Normalized Earnings Before Interest and Taxes ","Unadjusted Earnings Before Interest and Taxes ")&"""" &\$M\$10 &"""",IF(AND(\$M\$11="",\$O\$11="X",\$Q\$11=""),IF(\$T\$11="X","Normalize ","Unadjusted ")&\$O\$10,IF(AND(\$M\$11="",\$O\$11="",\$Q\$11="X")," "&\$Q\$12," EBIT, EBITDA or Other Method")))

Saurabh...
Bill Golden

I guess I should have been a little more specific.  Other times is will be the value of O10 which is EBITDA and sometimes Q10 which is definable.
I was hoping to understand how to format in place, but will use Substitute on EBIT and EBITDA if you can show me how to have two substitutes instead of one.
Thanks.
Did you try the formula which i told you??
SOLUTION
Missus Miss_Sellaneus

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Bill Golden

Saurabh...

Your solution get "s around "EBIT", not (EBIT).  I inserted a ( on the left and ) on the right and then got "(EBIT)"....but every time I tried to get rid of the ", I got and error.
Bill Golden

Sorry, when I inserted a ( on the left and ) on the right and then got ("EBIT")....still looking for just (EBIT)
Did you try my latest one?
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Okay so if the problem if i understand correct if M10 has double quotes in it..it shows...

as in if the value is "EBIT"

it shows ("EBIT") is my understanding correct?? You want to show it as (EBIT) rather..let me know if have missed something...
Bill Golden

Thanks guys. Both technically worked but went with Saurabh's for simplicity. Most important thing is the I learned something new.
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts

TRUSTED BY