Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to increase a number which is held in a cell by 1
How do i increase a cell which has a number in it, eg, cell a8 has 4
i want to run a If statment that looks at another cell and if true i want cell a8 to increse to 5 |
#2
|
|||
|
|||
You need VBA.
The code is simple in itself (Range("A1").Value = Range("A1").Value + 1), but what will trigger the addition to happen. -- HTH ------- Bob Phillips "Steve" wrote in message ... How do i increase a cell which has a number in it, eg, cell a8 has 4 i want to run a If statment that looks at another cell and if true i want cell a8 to increse to 5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
How to add the number in cell one by one in Hex format | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) |