Another Excel Question?

Question

Is there a way to have 3 diffrent choices of formulas? like for example ( 1year, 2year, and 3year) I need to calculate something diffrent for each one and I will have them in a drop down box. When someone chooses one, then it will have to calculate the correct formula for it to work. I tried the "IF" but it doesn't seem to work.

Answer 1

Yes, you can do exactly what you want and you are doing the right thing using IF.

Here is a quick spreadsheet example:

In Cell A1 type any number

In cell C1 create your drop down list button (1year, 2year, 3year).

In Cell E1 type the following formula (all on one line no spaces)
=IF(C1="1year",A1*10%,
IF(C1="2year",A1*20%,
A1*30%))

Done.

Change the calculations A1*10% etc to the calculations you want.