IF, with 3 outcomes

[krispatterson]

Hi guys

Basic one for you - data as follows:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]Y[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD]Y[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]N[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]M[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]N[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I want a formula in D1 that:

> looks at C1 - if "Y", shows A1
- if "N", shows B1
- if "M", shows 0


Is that do-able?

Thanks in advance!

 

[Jonmo1]

Is it really just those 3 possibilities, or are you simplifying a more complex scenario?
If it's not Y or N, can it be assumed to be M ?

Try
=IF(C1="Y",A1,IF(C1="N",B1,0))

 

[krispatterson]

Is it really just those 3 possibilities, or are you simplifying a more complex scenario?
If it's not Y or N, can it be assumed to be M ?

Try
=IF(C1="Y",A1,IF(C1="N",B1,0))

Thanks Jonmo - perfect. and yes, it really was that simple!!!