View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_4_] Sheeloo[_4_] is offline
external usenet poster
 
Posts: 225
Default 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.