Agrument or if/and statement

[Yevonne]

I have a spreadsheet that has counties in it. For Clarke I need it to put
city, for Jackson, Oglethorpe or Madison I need it to put RTZ and for all
others is AOZ.
=IF(=if(h1.h261=clarke=city), if(h1.h261='jackson', 'madison,
'oglethorpe'=rtz),"'clarke'=city, 'jackson',' madison','oglethorpe'
=rtz",false=aoz)
I entered it as an agrument to try and get both true statement in and also
a value if false.

 

[Sheeloo]

Try this in K
=IF(H1="Clark","City",IF(OR(H1="Jackson",H1="Madison",H1="Oglethorpe"),"RTZ","AOZ"))

and copy down...

 

[Fred Smith]

Try it this way:

=if(h1="Clarke","city",if(or(h1="Jackson",h1="Oglethorpe",h1="Madison"),"RTZ","AOZ"))

Fill this down column H.

Finally, buy a good book on Excel. It will save you a lot of time and
aggravation.

Regards,
Fred.

 

[Rick Rothstein]

Your syntax is wrong. Give this a try...

=IF(A1="Clarke","City",IF(OR(A1={"Jackson","Oglethorpe","Madison"}),"RTZ","AOZ"))

 

[Yevonne]

thank you to all. I have the John Walkenbach Excel 2003, but I could not find
the error.

 

[Fred Smith]

My apologies. My recommendation should have been to read the book.

Regards,
Fred.

 

[Yevonne]

Thank you so very much. I knew it was wrong, but would not find where.