Any Excel formula guru's?

Jameshill675 · 21 May 2007 at 16:44

I have a cell with a value in.

I want to be able to input another value into the cell ontop and the cell automatically calculate the total for for me.

help is much appreciated!

Smithy · 21 May 2007 at 16:45

Jameshill675 said:
I want to be able to input another value into the cell ontop

The cell on top as in the cell which is physicaly one row above? Or into the same cell?

Jameshill675 · 21 May 2007 at 16:52

Sorry mate i meant ontop of the value already inside the cell.

e.g. I want to be able to input 2105 into A1. The again type 2105 into A1 and it calculates up to 4210 for me.

Participant · 21 May 2007 at 17:00

WTF pea roast

fini · 21 May 2007 at 17:05

The only way that'd be possible would be with some VBA code - or just use a calculator tbh

Jameshill675 · 21 May 2007 at 17:14

Ah what a bummer!