Nested Function Question

D

Dave

I would like to write a formula which would find either of two words, such
as David and Grace, in a selected cell. =IF(C11="David",D11,0) etc., etc.
can be made to work for either word, but how can I get the second word (the
either /or word) into just one formula?
Thx much

Dave
 
D

Dave Peterson

Maybe...
=if(or(c11="david",c11="grace"),d11,0)


I would like to write a formula which would find either of two words, such
as David and Grace, in a selected cell. =IF(C11="David",D11,0) etc., etc.
can be made to work for either word, but how can I get the second word (the
either /or word) into just one formula?
Thx much

Dave
Click to expand...
 
D

Dave

Well OK - looks good. Guess I didn't have things nested quite deep enough.

Thx much

Dave
 
Top