| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
