Avatar of Bill Golden
Bill Golden
Flag for United States of America asked on

Value of a cell in Excel based on multiple factors

If C49 = X and C50= " ", then the value of D36
If C50 = X and C49= " ", then the value of D37
If both C49=X and C50 = X, then the value of D36+D37/2
Microsoft ExcelOffice Suites-OtherMicrosoft Office

Avatar of undefined
Last Comment
Bill Golden

8/22/2022 - Mon
Naresh Patel

Try This =IF(AND(C49="X",C50=" "),D36,IF(AND(C50="X",C49=" "),D37,IF(AND(C49="X",C50="X"),(D36+D37)/2,"")))

Thanks
Bill Golden

ASKER
Formula only works if C49 and C50 contain X!  If only C49 or only C50 contain an X, then value is blank.
ASKER CERTIFIED SOLUTION
Naresh Patel

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Bill Golden

ASKER
That did the trick,

Thanks,

Bill
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes