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
 
D

Dave

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

Thx much

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top