Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Please help me. I am very new to Excel. I am trying to subtract one column
from the next. I do not know where to put the formula; or even what the formula would be.? Signed Extremely Frustrated. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() To subtract Col B from Col C, assuming you have data in hte first 10 rows: Enter =A1-B1 in col C1. Then copy C1 down thru C10. Excel will adjust the formula as you copy down. To copy, select C1 and hit Crtl-C , then highlight c2:c10 and hit Ctrl-V. Alternatively, grab the lower RH corner of C1 & drag it down thru C10. Result will be that each cell in Col C is the difference of the corresponding cells in Cols A & B. You can try cruising thru the Excel "Help" contents for help on specific functions. ---GJC -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=526524 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hOW DO i SUBTRACT COLUMNS IN EXCEL? | Excel Discussion (Misc queries) | |||
Can I use Excel to match text data from 2 separate columns ? | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Add more lines and more columns in Excel | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |