Hi,
Arrange your table like this.
D18 E18 F18 G18 H18 D19 0 126 376 626 D20 0 1 2 3 4 D21 101 5 6 7 8
D22 301 9 10 11 12 D23 501 13 14 15 16
and the formula is
=INDEX(E20:H23,MATCH(B2,D20:D23),MATCH(A2,E19:H19))
Kris
--
FORUM RULES (986+ members already BANNED for violation)
Oh ok never saw it that way, I ended up doing this way
=IF(AND(F8<126;G8<16;H8<2);14,5;IF(AND(F8<376;G8<16;H8<4);16,5;IF(AND(F8<626;G8<16;H8<6);18,13;IF(AND(F8<1001;G8<16;H8<16);24,9;0
with 3 rules, do you think it´s viable this way, or should i "compact" to
your way in order to be more stable
=IF(AND(AND(A2>=126,A2<=375),(B2>=500)),10,0)
On Wed, Feb 29, 2012 at 10:57 PM, Jorge Marques wrote:
> Hi guys, i don´t know, how is this, my formula is wrong, if i change the
> weight beyond the limits it keeps giving 10. how can i change this, i think
> it´s simple, but i´m not finding a solu
Hi guys, i don´t know, how is this, my formula is wrong, if i change the
weight beyond the limits it keeps giving 10. how can i change this, i think
it´s simple, but i´m not finding a solution.
Thank you
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread
