SUM based on values in four cells

[pjzimm]

I've searched in vain with no luck. Please point me to a similar post or give me some advice on this *easy* formula.

I need H60 = D40 if there are no values in D41, D42, or D43.
I need H60 = D41 if there are no values in D40, D42, or D43.
I need H60 = D42 if there are no values in D40, D41, or D43.
I need H60 = D43 if there are no values in D40, D41, or D42.

What is the formula? Thank you in advance!

 

[texasalynn]

Welcome to the Board!

Try this

=IF(AND(D41="",D42="",D43=""),D40,IF(AND(D40="",D42="",D43=""),D41,IF(AND(D40="",D41="",D43=""),D42,IF(AND(D40="",D41="",D42=""),D43,0))))

HTH

 

[pjzimm]

It works! Thank you very much!