SpinnerTool

  • I am trying to create a spinner tool so that it increases / decreases a number in cell A1 and then at the same time increases / decreases a number in cell B2


    For example

    A1 = 1

    B2 = 3


    Press Up

    A1 now =2

    B2 now = 2


    Press Down

    A1 = 0

    B2 = 4


    Is this possible?

  • As Carim demonstrated, you just need to link the spinner to one of the cells and use a formula in the other cell (eg B2 =150-A1).

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!