Multiple IF Formula Question

[Rob]

I'm looking to do the following:

If C5=1, -C21*12.50%, IF C5=2, -C21*15.00%, IF C2=3 and so on all the way
until IF C5=10.

Thanks.

~~Rob

 

[Teethless mama]

The easy way is to set up a lookup table and use VLOOKUP function

 

[Duke Carey]

if the percentage increases by 2.5% for each integer increment in C5, then

=-c21*(.1+c5*.025)

this formula doesn't protect against C5 being something other than an
integer between 1 and 10

 

[Rob]

It doesn't increase by 2.5%
--
~~Rob

if the percentage increases by 2.5% for each integer increment in C5, then

=-c21*(.1+c5*.025)

this formula doesn't protect against C5 being something other than an
integer between 1 and 10

 

[Duke Carey]

Then you'll need to do what Teethless suggested: create a 2-column table
where the first column contains your integers 1 to 10, and the second column
contains the percentages. You'll then use a formula such as (assuming the
table is in cells A1:B10, and your integer value is in C5)

=-21*VLOOKUP(C5,a1:b10,2,0)

 

[Rob]

It worked thanks.

Just for my knowledge, why do you need 2,0 at the end of the formula?

 

[David Biddulph]

If you look up VLOOKUP in Excel help, it will tell you the syntax of the
function.

Excel help should usually be your first port of call if you're wanting
information on Excel.