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'

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'

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'

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 -