If Then Statement

  • Thread starter Add to distribution list without opening
  • Start date
A

Add to distribution list without opening

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

Roger Govier

Hi

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

Roger Govier


"Add to distribution list without opening"
 
P

Paul B

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

Ronster

Add said:
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!
Click to expand...

This works on my PC:

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

Gord Dibben

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

Entered in I4 or wherever.


Gord Dibben MS Excel MVP
 
Top