Quick Help

[Irwell]

Hi friends,

Can someone help me with working out a formula for the below, my head is hurting from getting wrong a few times.

Column A is a Yes or No
Column B is a number 1 to 4
Column C needs to be a formula that returns the following

"Code 1" if column b is 2 and column a is yes
"Code 2" if column b is 2 and column a is no
"Code 3" if column b is 3 and column a is yes
"code 4" if column b is 3 and column a is no

Many thanks,
Irwell

 

[Fluff]

What happens if B is 1 or 4?
Also what happens if A or B are blank?

 

[Irwell]

Think I've done it. Sorry to waste time

 

[Irwell]

What happens if B is 1 or 4?
Also what happens if A or B are blank?

Nothing if one or 4, no formulas kick in if A or B are blank. Think I've done it now though, thank you for responding.

 

[Fluff]

Glad you sorted it & thanks for the feedback

 

[Irwell]

Glad you sorted it & thanks for the feedback

Sometimes it is good to verbalise (or in this case type) something and it suddenly gives you a different perspective :D

 

[Fluff]

Agreed