multiple conditions in XL
 

hi all,here is the problem:
i need to check numbers and apply a pourcentage depending of the value.
there are 5 category of numbers and pourcentages.sample:
2 then pourcentage 1.8
6 " "" " 1.6
11 " " "" 1.4
16 " " " 1.3
21 " " " 1.1
Thanks for your help

multiple conditions in XL
 

If the values you mentioned is a range then try the below
=LOOKUP(A1,{0,2,6,11,21},{0,1.8,1.6,1.4,1.3,1.1})

or else use IF conditions
=IF(A1=2,1.8,IF(A1=6,1.6,(IF(A1=11,1.4 ....and so on


If this post helps click Yes
---------------
Jacob Skaria


"djinn" wrote:

hi all,here is the problem:
i need to check numbers and apply a pourcentage depending of the value.
there are 5 category of numbers and pourcentages.sample:
2 then pourcentage 1.8
6 " "" " 1.6
11 " " "" 1.4
16 " " " 1.3
21 " " " 1.1
Thanks for your help

multiple conditions in XL
 

thanks i will have a try and come back to you later on

"Jacob Skaria" wrote:

If the values you mentioned is a range then try the below
=LOOKUP(A1,{0,2,6,11,21},{0,1.8,1.6,1.4,1.3,1.1})

or else use IF conditions
=IF(A1=2,1.8,IF(A1=6,1.6,(IF(A1=11,1.4 ....and so on


If this post helps click Yes
---------------
Jacob Skaria


"djinn" wrote:

hi all,here is the problem:
i need to check numbers and apply a pourcentage depending of the value.
there are 5 category of numbers and pourcentages.sample:
2 then pourcentage 1.8
6 " "" " 1.6
11 " " "" 1.4
16 " " " 1.3
21 " " " 1.1
Thanks for your help

multiple conditions in XL
 

this don't seems to work.
thecondition is like:
if A1 is < 5 then multiply A1 by 1,8, if A1 is 5and <10 then multiply A1 by
1,6 and so on

"Jacob Skaria" wrote:

If the values you mentioned is a range then try the below
=LOOKUP(A1,{0,2,6,11,21},{0,1.8,1.6,1.4,1.3,1.1})

or else use IF conditions
=IF(A1=2,1.8,IF(A1=6,1.6,(IF(A1=11,1.4 ....and so on


If this post helps click Yes
---------------
Jacob Skaria


"djinn" wrote:

hi all,here is the problem:
i need to check numbers and apply a pourcentage depending of the value.
there are 5 category of numbers and pourcentages.sample:
2 then pourcentage 1.8
6 " "" " 1.6
11 " " "" 1.4
16 " " " 1.3
21 " " " 1.1
Thanks for your help

multiple conditions in XL
 

How about if the number is exactly 5 or exactly 10?

You haven't made any provision for that.

Define your parameters before saying it "don't work"

Is this closer?

=LOOKUP(A1,{0,6,11,16,21},{1.8,1.6,1.4,1.3,1.1})



Gord Dibben MS Excel MVP

On Fri, 26 Jun 2009 08:07:01 -0700, djinn
wrote:

this don't seems to work.
thecondition is like:
if A1 is < 5 then multiply A1 by 1,8, if A1 is 5and <10 then multiply A1 by
1,6 and so on

"Jacob Skaria" wrote:

If the values you mentioned is a range then try the below
=LOOKUP(A1,{0,2,6,11,21},{0,1.8,1.6,1.4,1.3,1.1})

or else use IF conditions
=IF(A1=2,1.8,IF(A1=6,1.6,(IF(A1=11,1.4 ....and so on


If this post helps click Yes
---------------
Jacob Skaria


"djinn" wrote:

hi all,here is the problem:
i need to check numbers and apply a pourcentage depending of the value.
there are 5 category of numbers and pourcentages.sample:
2 then pourcentage 1.8
6 " "" " 1.6
11 " " "" 1.4
16 " " " 1.3
21 " " " 1.1
Thanks for your help

multiple conditions in XL
 

i apologise, you are absolutely right the condition is something like:
if A1 is <= 5 then multiply A1 by 1,8, if A1 is 5 and <=10 then multiply A1
by
1,6 and so on
then should the formula be like this:
=LOOKUP(A1,{<=5,5<=10,10,<=15,etc...},{1.8,1.6,1 .4,etc...}) ???

"Gord Dibben" wrote:

How about if the number is exactly 5 or exactly 10?

You haven't made any provision for that.

Define your parameters before saying it "don't work"

Is this closer?

=LOOKUP(A1,{0,6,11,16,21},{1.8,1.6,1.4,1.3,1.1})



Gord Dibben MS Excel MVP

On Fri, 26 Jun 2009 08:07:01 -0700, djinn
wrote:

this don't seems to work.
thecondition is like:
if A1 is < 5 then multiply A1 by 1,8, if A1 is 5and <10 then multiply A1 by
1,6 and so on

"Jacob Skaria" wrote:

If the values you mentioned is a range then try the below
=LOOKUP(A1,{0,2,6,11,21},{0,1.8,1.6,1.4,1.3,1.1})

or else use IF conditions
=IF(A1=2,1.8,IF(A1=6,1.6,(IF(A1=11,1.4 ....and so on


If this post helps click Yes
---------------
Jacob Skaria


"djinn" wrote:

hi all,here is the problem:
i need to check numbers and apply a pourcentage depending of the value.
there are 5 category of numbers and pourcentages.sample:
2 then pourcentage 1.8
6 " "" " 1.6
11 " " "" 1.4
16 " " " 1.3
21 " " " 1.1
Thanks for your help

multiple conditions in XL
 

Try the below

=A1*LOOKUP(A1,{0,2,6,11,21},{0,1.8,1.6,1.4,1.3,1.1 })

If this post helps click Yes
---------------
Jacob Skaria


"djinn" wrote:

i apologise, you are absolutely right the condition is something like:
if A1 is <= 5 then multiply A1 by 1,8, if A1 is 5 and <=10 then multiply A1
by
1,6 and so on
then should the formula be like this:
=LOOKUP(A1,{<=5,5<=10,10,<=15,etc...},{1.8,1.6,1 .4,etc...}) ???

"Gord Dibben" wrote:

How about if the number is exactly 5 or exactly 10?

You haven't made any provision for that.

Define your parameters before saying it "don't work"

Is this closer?

=LOOKUP(A1,{0,6,11,16,21},{1.8,1.6,1.4,1.3,1.1})



Gord Dibben MS Excel MVP

On Fri, 26 Jun 2009 08:07:01 -0700, djinn
wrote:

this don't seems to work.
thecondition is like:
if A1 is < 5 then multiply A1 by 1,8, if A1 is 5and <10 then multiply A1 by
1,6 and so on

"Jacob Skaria" wrote:

If the values you mentioned is a range then try the below
=LOOKUP(A1,{0,2,6,11,21},{0,1.8,1.6,1.4,1.3,1.1})

or else use IF conditions
=IF(A1=2,1.8,IF(A1=6,1.6,(IF(A1=11,1.4 ....and so on


If this post helps click Yes
---------------
Jacob Skaria


"djinn" wrote:

hi all,here is the problem:
i need to check numbers and apply a pourcentage depending of the value.
there are 5 category of numbers and pourcentages.sample:
2 then pourcentage 1.8
6 " "" " 1.6
11 " " "" 1.4
16 " " " 1.3
21 " " " 1.1
Thanks for your help

multiple conditions in XL
 

unfortunately this formula returns an error.
On another hand i'm not sure it answer the condition described below?

"Jacob Skaria" wrote:

Try the below

=A1*LOOKUP(A1,{0,2,6,11,21},{0,1.8,1.6,1.4,1.3,1.1 })

If this post helps click Yes
---------------
Jacob Skaria


"djinn" wrote:

i apologise, you are absolutely right the condition is something like:
if A1 is <= 5 then multiply A1 by 1,8, if A1 is 5 and <=10 then multiply A1
by
1,6 and so on
then should the formula be like this:
=LOOKUP(A1,{<=5,5<=10,10,<=15,etc...},{1.8,1.6,1 .4,etc...}) ???

"Gord Dibben" wrote:

How about if the number is exactly 5 or exactly 10?

You haven't made any provision for that.

Define your parameters before saying it "don't work"

Is this closer?

=LOOKUP(A1,{0,6,11,16,21},{1.8,1.6,1.4,1.3,1.1})



Gord Dibben MS Excel MVP

On Fri, 26 Jun 2009 08:07:01 -0700, djinn
wrote:

this don't seems to work.
thecondition is like:
if A1 is < 5 then multiply A1 by 1,8, if A1 is 5and <10 then multiply A1 by
1,6 and so on

"Jacob Skaria" wrote:

If the values you mentioned is a range then try the below
=LOOKUP(A1,{0,2,6,11,21},{0,1.8,1.6,1.4,1.3,1.1})

or else use IF conditions
=IF(A1=2,1.8,IF(A1=6,1.6,(IF(A1=11,1.4 ....and so on


If this post helps click Yes
---------------
Jacob Skaria


"djinn" wrote:

hi all,here is the problem:
i need to check numbers and apply a pourcentage depending of the value.
there are 5 category of numbers and pourcentages.sample:
2 then pourcentage 1.8
6 " "" " 1.6
11 " " "" 1.4
16 " " " 1.3
21 " " " 1.1
Thanks for your help