View Single Post
  #8   Report Post  
Max
 
Posts: n/a
Default

Put in B1:

=IF(AND(A1=0,A1<=10),(A1-10)/100,IF(AND(A110,A1<=20),(A1-10))/100)


Apologies, correction to formula above

Think just put in B1: =(A1-10)/100
should do it ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----