Select Phrase from List then Change/Keep Formula in Another Cell

[ECB0000]

Say, I have a drop down list, where the user can select either "abc" or "qwe" in cell C1.

Now, if they select "abc" the formula in I1, K1, and N1:

$G1+($G1*0.015) will stay the same

but if the user selects "qwe", then the formulas in I1, K1, and N1 will change to:

$G1-($G1*0.015)

thus, changing the "+" to a "-". How can this be done without Macros or VBA - but rather way of an excel formula? How does one go about doing this? Looking for the easiest way so I this process can be automated and as simple as clicking either "abc" or "qwe" for the formulas to change.

Thank you!!!!

 

[David20]

Try an IF function in I1, K1, and N1:

=IF($C$1="abc",$G1+($G1*0.015),$G1-($G1*0.015))

If you need more than just two choices (abc/qwe/zxc) you can nest more IF functions for each possible choice.