help with spinners

  • Thread starter Thread starter Dumb_Question
  • Start date Start date
D

Dumb_Question

I am totally new to excel and have to use spinner form for clas
project. I did do some research on the internet but didnt really gras
much.

I am really not sure what the current value should be ....and wha
would be the linking cell. My workbook has 3 columns -----one show
percent change, other shows current values and the 3rd shows th
projected value. I need to put spinners on percent change.

I would appreciate your help. I am totally stuck!

Also, expect to see more of my (dumb!) posts
 
It really does not mater what you use for current value.
You cannot link the spinner directly to Percent Change since spinner allows
integer values only.
Link it to 'dummy' cell (say G3) with Min value 0, Max value 1
In Percent Change cell use =G3/100 and format as %
You can hide G3 (or where ever you link) by dragging the spinner over it
 
Bernard...thanks that worked great!
Now if I had to make values nagative...how would I do that?

Dumb
 
Hi,
Change the spinner's limits from 0->100 to 0->200; that values goes in, say,
G3
In the 'actual' cell use =(G3-100)/100 and format as percent
Now this gets you a range -100% to +100% in increments of 1
If you make the spinner range )->2000, and use =(G3-1000)/1000 you will get
increments of 0.1%
 
Back
Top