Multiple IF Formula Question
 

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

Multiple IF Formula Question
 

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


"Rob" wrote:

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

Multiple IF Formula Question
 

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" wrote:

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

Multiple IF Formula Question
 

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


"Duke Carey" wrote:

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" wrote:

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

Multiple IF Formula Question
 

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" wrote:

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


"Duke Carey" wrote:

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" wrote:

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

Multiple IF Formula Question
 

It worked thanks.

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


"Duke Carey" wrote:

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" wrote:

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


"Duke Carey" wrote:

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" wrote:

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

Multiple IF Formula Question
 

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.
--
David Biddulph

"Rob" wrote in message
...
It worked thanks.

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


"Duke Carey" wrote:

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" wrote:

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


"Duke Carey" wrote:

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" wrote:

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