| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need some help with Excel 2003..?
I have list selection cell with 4 words in it. i want another cell to display
1 value if one of the four words is selected and another if the other three are selected... basically a list with a,b,c,d and another box that will display x if a,b,c are selected and y if d is selected. I tried =if(c17="a","x",""), etc... along with =if(c17="d",y","") and all I get back is TRUE not my x or y... HELP!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need some help with Excel 2003..?
Try =IF(G1="d","y","x")
HTH Regards, Howard "djsurreal3" wrote in message ... I have list selection cell with 4 words in it. i want another cell to display 1 value if one of the four words is selected and another if the other three are selected... basically a list with a,b,c,d and another box that will display x if a,b,c are selected and y if d is selected. I tried =if(c17="a","x",""), etc... along with =if(c17="d",y","") and all I get back is TRUE not my x or y... HELP!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
| Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
| Transferring Large Amount of Data from Excel 2003 to Access 2003 | Excel Programming | |||
| Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
| Word 2003 Find/Change Automation from Excel 2003 crashes Excel 200 | Excel Programming | |||
Linear Mode
