Bill Golden

asked on

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

=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

=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...

=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??

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?

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