Excel "if" formula based on other cell inputs

[sm008]

Hello,

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>

 

[tygrrboi]

Where is the information in B1 coming from?

Are you manually putting in the number?

Cells cannot hold formulas and values at the same time. Would it be possible to have C1 show the result of B1 increased by a number determined in your A Column?

Like

for your first question.

C1 = B1 + B1 * ((5*CountIf(A1:A3, "yes")/100)

for your second question, if you mean increase B1 by 0, 1 or 2 percent then...

C1 = B1 + B1 * ((CHOOSE(A1+1, 2, 1, 0))/100)

otherwise just

B1 = Choose(A1 + 1, 2, 1, 0)/100

 

[Anand Sharma]

Hi

You can use if condition here, try out below code

=IF(E9=2,0%,IF(E9=1,1%,IF(E9=0,2%,"")))


If you want to talk live, I'm part of an experiment where we are trying out free, instant chat sessions between a problem submitter and an excel expert like me. Feel free to try it! Or you can continue here, that's fine too.

 

[yky]

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%".

b1=(2 - a1)/100

 

[sm008]

Hey, so for the first example, B1 would not have anything unless "yes" existed in one of the three cells A1 A2 A3. If one "yes", 5%, if two "yes", 10%, if three "yes", 15%. If 0 "yes", nothing.

Also I forgot to mention for the 2nd example, let's say the result is 2% in B1 - Is there any way to include that 2% from the IF formula in a SUM function for another cell? For example, if I want to add the 2% from that cell together with other percentages from other cells as a SUM total?

Hope I am making sense.

Thanks

 

[sm008]

b1=(2 - a1)/100

Thanks!