Excel formula

[Kerplunk]

On a spreadsheet I want the following in Cell C1:

 

If A1 = yes then C1 = 13, but if A1 = No then C1 = 11. which I have done using the following formula for C1:

 

=IF((A1="yes"),13,IF((A1="no"),11,""))

 

However, I want to add that if Cell B1 is empty then C1 should be empty no matter what is in A1.

I hope this makes sense and thanks for any help.

[stevie21]

=IF((B1=""),"",IF((A1="yes"),13,IF((A1="no"),11,"")))

[Kerplunk]

Excellent, thank you very much.

[Gandy]

Stevie - know any useful websites or books that explain formulas?  I can see the potential that Excel has in my line of work and need to explore.

[stevie21]

Sorry Gandy, not really. I've programmed a little in a few languages so IF statements appear everywhere. It's just a matter of using the right syntax.
I know that Excel & formulas appear on the ECDL so I'd maybe look at that.

If there's a particular function that I want Excel to perform I just look on google and see what appears.
Alternatively you could have a look at Excel's help section or post a question here?