kskinne, answer was close

[dhammell]

Please refer to my posting from 11/6. The alpha problem is solved, but formula returns a 0 value for numbers between 767000 and 93971. Example:
767000 11.95 10.16
kl51x2 12.70 blank
769000 10.50 Blank***
***should be 8.93 Your formula was
=IF(ISNUMBER(A1),IF(AND(A1<=767000,A1>=93971,B1*.85,""),"") This is driving me crazy.

 

[Andrew Poulsom]

769000 is more than 767000 isn't it?