Add a number to the current cell

  • Thread starter Thread starter kirkl_uk
  • Start date Start date
K

kirkl_uk

I have a cell that contains a value, eg 10. If I then type 5 whilst thi
cell is selected, 10 is replaced by 5. However, what I would like i
for the 5 to be added to the current value, 10, so that the new cel
value is 15, rather than 5. Can you help?

Thanks,
Kir
 
Hi i can help you with a trick if your incremental increase is constan
of a certain number you want .
first from your toolbar view allow the forms and then click the spinne
and insert in a place then click right and open format control , unde
incremental change , write the number you need , and in the cell lin
choose the cell you have the value already in it (ex A1=10), finall
click ok , and your cell will incrementally increase while spinning u
and down with that spinner form .

I hope this will help you , otherwise you need a macro for that .

Rgds,
gaftali
 
Back
Top