How do I add the value of two cells together?

Feb 25th, 2002, 04:16 AM

I hope someone could answer this question for me as it would save me a lot time because at the moment I have a calculator next to me.

dk · Feb 25th, 2002, 04:50 AM

Excel provides no way of adding two cells together directly. The way I usually do it is to convert the numbers to binary (on a paper notepad), add them using twos compliment arithmetic and then convert the answer back to decimal. I then type the sum of the two cells somewhere on the worksheet. I also include a comment saying something like 'Sum of cells A1 and B1' so people will update the cell if A1 or B1 change.

HTH,
D

[ This Message was edited by: dk on 2002-02-25 03:52 ]

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

Feb 25th, 2002, 04:16 AM	#1
Guest Posts: n/a	I hope someone could answer this question for me as it would save me a lot time because at the moment I have a calculator next to me.

Feb 25th, 2002, 04:50 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Excel provides no way of adding two cells together directly. The way I usually do it is to convert the numbers to binary (on a paper notepad), add them using twos compliment arithmetic and then convert the answer back to decimal. I then type the sum of the two cells somewhere on the worksheet. I also include a comment saying something like 'Sum of cells A1 and B1' so people will update the cell if A1 or B1 change. HTH, D [ This Message was edited by: dk on 2002-02-25 03:52 ]