in column L are Totals points
in column K are Temporary points
and i want to make rank according to points in L and K
less than 2000 of total points = C1
2000-6000 of total points = C2
6000 and more of total points = C3
BUT
if have 3000+ temporary points and 18000+ total points = M1 until
76 000+ temporary points = M2
200 000+ temporary points = R1
400 000 + temporay points = R2
i try it like that
=IF(AND(L1>1999,9;L1<6000);"C2";IF(L1>5999,9;"C3";IF(AND((K1>2999,99);(L1)>17999,99);"M1";IF(K1>75999,9;"M2";IF(K1>199999,9;"R1";IF(K1>399999,9;"R2";"C1"))))))
but it works, but not correctly..for example if have 8606088,566 temporary and 220000 totals it write C3 but it is R2
maybe it is only problem with parentheses or wrong true, false in if..i am clueless..please help me
Bookmarks