Incrementing by .00001 with spinner control button

[DashboardNovice]

In the attached file, I am trying to get the value in cell H12 to increment by 0.00001 every time I click the spinner button up or down. Seems like the incremental change cannot be below 1.

First I would like to set the value in cell H12 to the value I have in cell H8.

Cell F12 has the current value of the spinner button.

H12 has the value that should change by 0.00001 each time I click the spinner button up or down.

In order to make H12 increment by 0.00001, I have to use a conversion factor of some sort in cell G12.

So with all this in mind, I am having trouble

1. Setting cell H12 to 1.11820.
2. Determining the correct conversion factor to use in cell G12 (assuming that a conversion factor is the best way to go).

 

[Chihiro]

Not sure what you are trying to do here... but can't you just multiply F12 by 0.00001 & add to G12?

So when F12 = 0, G12 = 1.1182

Formula in H12 =G12+F12*0.00001

See attached.

 

[vletm]

DashboardNovice
... or this one?

 

[DashboardNovice]

Not sure what you are trying to do here... but can't you just multiply F12 by 0.00001 & add to G12?

So when F12 = 0, G12 = 1.1182

Formula in H12 =G12+F12*0.00001

See attached.

Perfect. This is exactly what I was looking for. Handling the conversion factor threw me off.

 

[DashboardNovice]

DashboardNovice
... or this one?

This also worked. Thank you very much.