formula add value in 3 column

  • Thread starter Thread starter siza_05
  • Start date Start date
S

siza_05

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!
 
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?
 
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
(e-mail address removed)










- 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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top