Agrument or if/and statement

  • Thread starter Thread starter Yevonne
  • Start date Start date
Y

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.
 
Try this in K
=IF(H1="Clark","City",IF(OR(H1="Jackson",H1="Madison",H1="Oglethorpe"),"RTZ","AOZ"))

and copy down...
 
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.
 
Your syntax is wrong. Give this a try...

=IF(A1="Clarke","City",IF(OR(A1={"Jackson","Oglethorpe","Madison"}),"RTZ","AOZ"))
 
thank you to all. I have the John Walkenbach Excel 2003, but I could not find
the error.
 
Back
Top