| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| How can I choose a date from list with an agrument? | Excel Worksheet Functions | |||
| How to use the "Fr" function, what is agrument | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
