| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statements
I want to enter one of two values in column A and one of two (different) values in column B. In column C I want Excel to compute a value for each of the 4 possible combinations of values in columns A and B on a particular row. Eg if A1 = urgent and B1 = important, C1 = 'Q1' if A1 = non-urgent and B1 = important, C2 = 'Q2' |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statements
in C1:
=IF(A1="Urgent",IF(B1="Important","Q1","Q3"),IF(B1 ="Important","Q2","Q4")) (I've assumed Q4 is Non-urgent/Non-Important and Q4 is Urgent/Non-Importnant) "the richard and judy show" wrote: I want to enter one of two values in column A and one of two (different) values in column B. In column C I want Excel to compute a value for each of the 4 possible combinations of values in columns A and B on a particular row. Eg if A1 = urgent and B1 = important, C1 = 'Q1' if A1 = non-urgent and B1 = important, C2 = 'Q2' |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statements
What are the allowed values in A1 and in B1, and what are the outcomes
that you require? In your last example, should it be C1 = 'Q2' ? Pete On Sep 9, 11:23*am, the richard and judy show wrote: I want to enter one of two values in column A and one of two (different) values in column B. In column C I want Excel to compute a value for each of the 4 possible combinations of values in columns A and B on a particular row. Eg if A1 = urgent and B1 = important, C1 = 'Q1' if A1 = non-urgent and B1 = important, C2 = 'Q2' |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statements
On 9 Sep, 11:36, Sam Wilson
wrote: in C1: =IF(A1="Urgent",IF(B1="Important","Q1","Q3"),IF(B1 ="Important","Q2","Q4")) (I've assumed Q4 is Non-urgent/Non-Important and Q4 is Urgent/Non-Importnant) "the richard and judy show" wrote: Perfect - thanks a ton. I want to enter one of two values in column A and one of two (different) values in column B. In column C I want Excel to compute a value for each of the 4 possible combinations of values in columns A and B on a particular row. Eg if A1 = urgent and B1 = important, C1 = 'Q1' if A1 = non-urgent and B1 = important, C2 = 'Q2'- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if statements | New Users to Excel | |||
| If Statements | Excel Worksheet Functions | |||
| IF Statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| if/then statements | Excel Worksheet Functions | |||
Linear Mode
