"Ntisch" wrote in
message ...
Interestingly the first formula -
=1*if(And(A1=1,A1<=3),.10,if(And(A1=4,A1<=7),.20 ,if(And(A1=8,A1<=10),.3,0
)))
Failed to work even though I wasn't using integers.
This formula will not work for any value between, (but not including), 3 &
4, and 7 & 8. Could that explain the failure?
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk