If or, If And 1

[shytott]

Hi All
Is there an ‘if and’ / ‘if or’ combo that will let me do the following:
In a worksheet of 365 entries, in col C, “m” ,“a” or blank can appear, and in Col D, “s” or blank can appear. If I get the combo of “m” and “s”, I’d like to use the value housed in A1. If the combo is “a” and “s”, I’d like the answer to be from B1. All other combos to be blank.

Many Thanks

 

[bluedragon2]

=IF(AND(C1="m",D1="s"),A1,IF(AND(C1="a",D1="s"),B1,""))

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[shytott]

Wow
Thanks Blue - 5 minute turnaround, that has to be a record! Knew it had to be a simple solution - I was omitting the 2nd '(and('

Very Impressed
Cheers
Shy