Hi,
Could somebody explain me why my formula works with negative values and not with positive?
=IF(ABS(VLOOKUP(E24,P108:T113,5,FALSE))>S109,U18,IF(ABS(VLOOKUP(E24,P108:T113,5,FALSE))>R109,U17,IF( ABS(VLOOKUP(E24,P108:T113,5,FALSE))>Q109,U16,U15)))
can you explain what you trying to do?
"Relax. What is mind? No matter. What is matter? Never mind!"
what's your value in say s1009
say its +20 and vlook up returns -50 then abs(-50)=50 and is greater but if vlookup returns +11 abs(+11)=11 then its smaller so onto next if ...and so on ;so as zbor says what is it you're trying to do, what doesnt work where?
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Methods Data1 Data2 Data3 Amount
A 800000 900000 1000000 -5000000
B 800000 900000 1000000 -3000000
C 800000 900000 1000000 -2000000
D 800000 900000 1000000 3000
E 1600000 1800000 2000000 25000
=IF(ABS(VLOOKUP(Method,A1:E6,5,FALSE))>Data3,"BREACH",IF(ABS(VLOOKUP(Method,A1:E6,5,FALSE))>Data2,"A LERT",IF(ABS(VLOOKUP(Method,A1:E6,5,FALSE))>Data1,"WARNING","OK")))
I receive result "BREACH" when I use Method D and E that incorrect. Result should be "OK"
Where is my fault?
If you are using named ranges, the formula will always refer to that cell. In the first instance, you used cell references. Is it possible to post a sanitized copy of the workbook so we can see which you're using? The formula works fine for me when I use normal cell references.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks