The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium.
Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

=IF(AND($M$11="X",$O$11=""

Saurabh...

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.

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.

Saurabh...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trialas 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...

Microsoft Excel

From novice to tech pro — start learning today.

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium.
Start your 7-day free trial.