if cell contains "yes", then 5, if cell contains "no", then 14 on the right cell

Hi all,

I'm looking for a formula that will look in a cell and if it finds the word "yes", then it should put a value of 5 in the cell right of it, if it has the word "no", then it should put 14 in the cell to the right.

Is there a way to do this? I have simply found nothing on this.

Thanks in advance,
megatronixs

in c5 test b5

if(b5="yes",5,if(b5="no",14,""))