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.

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.

I did that, but when I click on the cell the next number is positive 1 and
does not go below zero again.

"Max" wrote:

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.

Not sure that I understand you <g, but the suggestion means that *A2* is now
used as the "cell-link" for any downstream formulas to refer to, not B2
(which is the actual spinner's cell link)

When you click to advance the spinner, you'll get only negative numbers
appearing in *A2* (Don't look at / refer to B2 anymore)

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

"Vix" wrote:

I did that, but when I click on the cell the next number is positive 1 and
does not go below zero again.

"Max" wrote:

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.

Nope. Still did not work.

Here is what I've done

Problem: To evaluate +/- change by spinning 1% up or down.
Set A1=1; B1=100
Set A2=(A1/B1)%
Assign Spinner to Cell = A1

As soon as I assign spinner to B1 = a negative # (as you suggested)...after
the first spin the number goes to zero and only goes up!
Hope this helps.
Vix

"Max" wrote:

Not sure that I understand you <g, but the suggestion means that *A2* is now
used as the "cell-link" for any downstream formulas to refer to, not B2
(which is the actual spinner's cell link)

When you click to advance the spinner, you'll get only negative numbers
appearing in *A2* (Don't look at / refer to B2 anymore)

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

"Vix" wrote:

I did that, but when I click on the cell the next number is positive 1 and
does not go below zero again.

"Max" wrote:

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.

Nope. Still did not work.

Here is what I've done

Problem: To evaluate +/- change by spinning 1% up or down.
Set A1=1; B1=100
Set A2=(A1/B1)%
Assign Spinner to Cell = A1

As soon as I assign spinner to B1 = a negative # (as you suggested)...after
the first spin the number goes to zero and only goes up!


"Max" wrote:

Not sure that I understand you <g, but the suggestion means that *A2* is now
used as the "cell-link" for any downstream formulas to refer to, not B2
(which is the actual spinner's cell link)

When you click to advance the spinner, you'll get only negative numbers
appearing in *A2* (Don't look at / refer to B2 anymore)

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

"Vix" wrote:

I did that, but when I click on the cell the next number is positive 1 and
does not go below zero again.

"Max" wrote:

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.

Maybe try something along these lines

Make the spinner settings as:
Current value: 10
Min: 0, Max: 20
Cell link: A1

Put in B1:

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

Format B1 as percentage, to zero dp

Now try clicking on the spinner's up arrow:
B1 will increment in steps of 1%, viz.: 1%, 2% ... 10%

Clicking down decrements B1 in steps of 1%
and will enable B1 to show (past B1 = 0%): -1%, -2% ... -10%

As before, we can now point other formulas to B1 as the spinner output
(instead of A1)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Vix" wrote:

Nope. Still did not work.

Here is what I've done

Problem: To evaluate +/- change by spinning 1% up or down.
Set A1=1; B1=100
Set A2=(A1/B1)%
Assign Spinner to Cell = A1

As soon as I assign spinner to B1 = a negative # (as you suggested)...after
the first spin the number goes to zero and only goes up!
Hope this helps.
Vix

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