Modifying the contents of a cell using the cell itself

Mar 14th, 2002, 07:15 AM

Hello, Is it possible to change the contents of a numeric cell by adding a 1 for example using the contents of the cell itself like:
C1=15 and D1=1
If D1=1 then C1=C1+1
Hope I was clear. Thanks you anyway.
Anarna

Derek · Mar 14th, 2002, 07:23 AM

Hi
I don't think you can do this by formula but you can do it by vb code:

If Range("D1").Value = 1 Then Range("C1").Value = Range("C1").Value + 1

(code is all on one line)
hope this helps
regards
Derek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 07:15 AM	#1
Guest Posts: n/a	Hello, Is it possible to change the contents of a numeric cell by adding a 1 for example using the contents of the cell itself like: C1=15 and D1=1 If D1=1 then C1=C1+1 Hope I was clear. Thanks you anyway. Anarna

Mar 14th, 2002, 07:23 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi I don't think you can do this by formula but you can do it by vb code: If Range("D1").Value = 1 Then Range("C1").Value = Range("C1").Value + 1 (code is all on one line) hope this helps regards Derek