formula not working
I'm not sure why this isn't working ... please help.
A B
0.999 1
0.799 2
0.699 3
0.599 4
0.499 5
0.399 6
0.299 7
0.199 8
0.99 9
I just need to lookup a value in ,say, C1 and compare to colA and return a
value in colB.
Using: =IF(M41=0,10,IF(M411,0,VLOOKUP(M41,$C$60:$D$68,2) ))
yields #N/A for any value not 0 or 1.
What gives?
|