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.
|