So let's say I have cells A1, A2, A3. In each of the cells, there is either "yes", or nothing. If one of the cells says "yes", I want cell B1 to increase by 5%. If 2 of the cells say "yes", I want B1 to increase by 10%. If all 3 cells says "yes", I want B1 to increase by 15%. Help plz?

Also, similar to above (might be the same formula):

Cell A1 can say "2", "1" or "0". If cell A1 has "2", I want cell B1 to have "0%". If cell A1 has "1", B1 should have "1%". Finally, if A1 has "0", B1 should have "2%".

Thanks in advance for your help!

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>

</tbody>