| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple nested if and statement
Is anyone able to help with the following? I have data with relationships represented in columns A and B and want to create a function to give the output in the final column. I think I need a nested if / and statement but not sure exactly how to configure it. Col A Col B Output Apples Apples Full Apples Oranges Partial Oranges Apples None Oranges Oranges None Many thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Simple nested if and statement
Hi,
Am Thu, 23 Jan 2014 11:06:32 -0800 (PST) schrieb GW: Col A Col B Output Apples Apples Full Apples Oranges Partial Oranges Apples None Oranges Oranges None try: =IF(A1&B1="ApplesApples","Full",IF(A1="Apples","Pa rtial","None")) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Simple nested if and statement
That does the trick! Thanks very much indeed.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple question?? Nested ifs on one line | Excel Programming | |||
| Simple nested if statement | Excel Discussion (Misc queries) | |||
| Nested IF Statement Help | Excel Discussion (Misc queries) | |||
| simple nested loop question | Excel Programming | |||
| Nested IF statement | Excel Discussion (Misc queries) | |||
Linear Mode
