If Then Statement
 

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!

If Then Statement
 

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!

If Then Statement
 

See if this will do what you want,
=IF(AND(I2="mudstone",I3="Coal"),1,"")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"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!

If Then Statement
 

Add to distribution list without opening 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!

This works on my PC:

=IF(AND(A1="mudstone",B1="coal"),1,0)

If Then Statement
 

=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!