=IF(AND(I2="mudstone",(I3="Coal")),1,"message when not")

Entered in I4 or wherever.


Gord Dibben MS Excel MVP

On Thu, 19 Oct 2006 16:03:01 -0700, Add to distribution list without opening
icrosoft.com wrote:

I want to do an If then statement in Excel like If I2 = mudstone and I3 =
Coal the value is 1.

I have worked on this all afternoon and I am stumped!

Please help!