Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
How do I add multiple values that match multiple conditions? | Excel Discussion (Misc queries) | |||
Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |