Agrument or if/and statement
 

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.

Agrument or if/and statement
 

Try this in K1
=IF(H1="Clark","City",IF(OR(H1="Jackson",H1="Madis on",H1="Oglethorpe"),"RTZ","AOZ"))

and copy down...

"Yevonne" wrote:

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.

Agrument or if/and statement
 

Try it this way:

=if(h1="Clarke","city",if(or(h1="Jackson",h1="Ogle thorpe",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.

"Yevonne" wrote in message
...
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.

Agrument or if/and statement
 

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

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

--
Rick (MVP - Excel)


"Yevonne" wrote in message
...
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.

Agrument or if/and statement
 

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

"Fred Smith" wrote:

Try it this way:

=if(h1="Clarke","city",if(or(h1="Jackson",h1="Ogle thorpe",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.

"Yevonne" wrote in message
...
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.

Agrument or if/and statement
 

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

Regards,
Fred.

"Yevonne" wrote in message
...
thank you to all. I have the John Walkenbach Excel 2003, but I could not
find
the error.

"Fred Smith" wrote:

Try it this way:

=if(h1="Clarke","city",if(or(h1="Jackson",h1="Ogle thorpe",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.

"Yevonne" wrote in message
...
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.

Agrument or if/and statement
 

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

"Rick Rothstein" wrote:

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

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

--
Rick (MVP - Excel)


"Yevonne" wrote in message
...
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.