Thread: Button to add/decrease value to a number of cells

I'm trying to include two buttons to an Excel sheet - an UP button and a DOWN. These buttons will increase (or decrease) another column of cells (for eg. A1, B3, C7...) by increments of 0.1 on each click.

These cells (A1, B3, C7... as above) will also have an IF function corresponding to a drop down list (=IF(A100="Shirt",10,"") In other words, a they will have a BASE number once an item is slected from the drop down list. I want to increase/dcrease these numbers by 0.1 when I click the UP and DOWN buttons.

I'm using Excel 2003 if it helps. Thank you very much for any help you can provide.

A cell has a value (number, text, whatever) or a formula in it. It can't have both.

If you have a value in it, you could have buttons to increase it or decrease it.

The only way that I can think of that you can do this is to have a separate cell, which your formula has a dependency on, that you increase or decrease.

Why do you want to do this?

Regards

I'd be inclined to have a matrix with the 10 states across the top and the products down the left column. I'd include the base price for each product and increments for each state.

In the example attached, the increments are simple numbers but you could make them percentage increases.

If you name each State column and each Product row, you can have a simple formula, for example,
=StateA Watch

Even if you don't choose that, with the matrix, you could have two drop down boxes, one for product and one for state, and use something like SUMPRODUCT or INDEX/MATCH.

Regards

Same example with drop down boxes

Regards

You're welcome. Thanks for the feedback.