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

Supposing the spinner's cell link is: B2

You could put in say, A2: =-B2
and then use A2 (instead of B2)
as the reference cell to point to, for formulas elsewhere

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Vix" wrote:

Hi,

I'm using the Spinner function and would like to assign a negative value.
The system menu does not allow me to assign a value below zero.

How can I add a negative value.

Thanks.