close
To subtract B1 from A1 with result in C1
in C1 put
=A1-B1 (= sign is required as this tells Excel it is a formula)
To repeat this for B2 form A2 etc, copy the formula into C2.
To copy a formula down i.e. to many cells, click on C2, hold cursor over
bottom right hand of cell (black square) until cross appears, hold left mouse
button and drag cursor down as far as required.
HTH
quot;Subtract columnsquot; wrote:
gt; Please help me. I am very new to Excel. I am trying to subtract one column
gt; from the next. I do not know where to put the formula; or even what the
gt; formula would be.? Signed Extremely Frustrated.
全站熱搜
留言列表
