if statements

[the richard and judy show]

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'

 

[Sam Wilson]

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)

 

[Pete_UK]

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

 

[the richard and judy show]

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)

:

Perfect - thanks a ton.