ExcelBanter - formula add value in 3 column

On Aug 27, 5:58*pm, "Nigel" wrote:
Is it simply a formula to add column A and column B?

Then put in column C the following

* *=An + Bn

where n = row number

But I am sure that is not what you are asking?

--

Regards,
Nigel

wrote in message

...

how do i do if i want any value in column A and column B was add..and
the result is in Column C
this is what i mean..

Column A + Column B = Column C
or more easier to understand , A+B=C

it doesnt matter which cell/row/range that value located but still in
column A or B...and the result in column C

hope understand

thanks in advance!- Hide quoted text -

- Show quoted text -

yup..what i actually mean is for one sheet...did i need to write a
formula for each cell in one sheet?
what i'm trying to do is ..when i key in the number in column A
(cell), its must be automatic add with value in column B(cell) and
display in column C(cell)

it must be work only on number not character or capital letters or
whatever else except number..i try to record macro with i highlight
whole column A, column B and column C ...with formula A+B=C but it
only function on fisrt cell..i want the whole cell have the formula..

thanks! hope understand!