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