Multiple IF Formula Question

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
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
 
It doesn't increase by 2.5%
--
~~Rob


Duke Carey said:
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
Click to expand...
 
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)
 
Back
Top