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) |