ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I subtract column 1 from 2 and show results in 3?HELP! (https://www.excelbanter.com/excel-worksheet-functions/19746-how-do-i-subtract-column-1-2-show-results-3-help.html)

ks

How do I subtract column 1 from 2 and show results in 3?HELP!
 


CLR

In cell C1 put this formula

=B1-A1

then select C1 and pick on the little black square in the lower right corner
and drag it down column C as many rows as you have data in A and B.
This will automatically put =B2-A2 in cell C2, and =B3-A3 in cell C3, etc
etc all the way down...........

Vaya con Dios,
Chuck, CABGx3


"ks" wrote in message
...





All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com