Bill Golden

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

If C50 = X and C49= " ", then the value of D37

If both C49=X and C50 = X, then the value of D36+D37/2

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

That did the trick,

Thanks,

Bill

Thanks,

Bill

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