Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the formula for adding a new number to the existing numbe.
A1=A1+B2 gives inconsistant results, is there another way to do this?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the formula for adding a new number to the existing numbe.
Inconsistant results? I find that hard to believe! This type of statement is
used heavily in VBA to self-increment a variable and has never failed me- unless your code is not right! -- | +--Thief_ | "jimb" wrote in message ... A1=A1+B2 gives inconsistant results, is there another way to do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the formula for adding a new number to the existing numbe.
Assuming that this is a line of vba code, you must keep in mind that
everytime you run through this line the results in cell A1 will be different ! Let's say that B2 contains the value of 10 and A1 contains 5 After running this code line, A1 will = 15 If it is run again BEFORE B2 changes, then A1 will = 25 and will increment by 10 each run as long as something does not change B2 However, you may have something changing cell B2 in between incidents of running the code. If so A1 will be increased by the value of B2 at the time the code is run. "jimb" wrote: A1=A1+B2 gives inconsistant results, is there another way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding in an 'IF' to existing formula | Excel Discussion (Misc queries) | |||
Adding to an existing formula | Excel Worksheet Functions | |||
Adding selected numbe in a column | New Users to Excel | |||
What is the formula for adding a number of days to an existing dat | Excel Worksheet Functions | |||
How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) |