# Excel "if" formula based on other cell inputs

#### sm008

##### New Member
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%".

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

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
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

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

Last edited:
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.

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

Last edited:
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

Replies
1
Views
266
Replies
14
Views
1K
Replies
4
Views
1K
Replies
3
Views
216
Replies
0
Views
246

1,196,487
Messages
6,015,495
Members
441,898
Latest member
kofafa

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back