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
|