Placing Text within a formula in MS Excel
I have the following formula...
=IF(AND($M$11="X",$O$11=""
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
=IF(AND($M$11="X",$O$11=""
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
Last Comment
Missus Miss_Sellaneus
=SUBSTITUTE(IF(AND($M$11="
You can simply do this to get what you are looking for...
=IF(AND($M$11="X",$O$11=""
Saurabh...
=IF(AND($M$11="X",$O$11=""
Saurabh...
ASKER
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.
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
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.
ASKER
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.
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.
ASKER
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?
ASKER CERTIFIED SOLUTION
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...
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...
ASKER
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
