Value of a cell in Excel based on multiple factors

Bill Golden
Bill Golden used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Naresh PatelFinancial Adviser

Commented:
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 GoldenExecutive Managing Member

Author

Commented:
Formula only works if C49 and C50 contain X!  If only C49 or only C50 contain an X, then value is blank.
Financial Adviser
Commented:
Becoz in your post you mention " " but I guess it is for blank cell then it should be like this "".

replace " " to "" in formula.

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

Thanks
Bill GoldenExecutive Managing Member

Author

Commented:
That did the trick,

Thanks,

Bill

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial