Hi

IF(AND( I2 ="mudstone", I3 ="Coal"),1,"")
-
-
Regards

Roger Govier


"Add to distribution list without opening"
icrosoft.com wrote in
message ...
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!