Thread
:
Spinner properties: Minimum value. How do I assign negative value.
View Single Post
#
8
Max
Posts: n/a
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
----
Reply With Quote