View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yevonne Yevonne is offline
external usenet poster
 
Posts: 4
Default 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.