| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make A-B=C
I am trying to manage a few things I am selling and shipping off. In column a
I have the price I sold it for. In column b I have the shipping price that was charged and in c I have the total profit made which is a-b, Is it possible to format them so it automatically subtracts from B from A so I can get C? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make A-B=C
In C1 type the formula
=A1-B1 then copy it down Col C in the cells you want the same calculation... for C2 it will change to =A2-B2 and so on... "Gundown64" wrote: I am trying to manage a few things I am selling and shipping off. In column a I have the price I sold it for. In column b I have the shipping price that was charged and in c I have the total profit made which is a-b, Is it possible to format them so it automatically subtracts from B from A so I can get C? Thanks in advance! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make A-B=C
Do I have to go down each column and change the number to the corresponding
row or is there an easier way? "Sheeloo" wrote: In C1 type the formula =A1-B1 then copy it down Col C in the cells you want the same calculation... for C2 it will change to =A2-B2 and so on... "Gundown64" wrote: I am trying to manage a few things I am selling and shipping off. In column a I have the price I sold it for. In column b I have the shipping price that was charged and in c I have the total profit made which is a-b, Is it possible to format them so it automatically subtracts from B from A so I can get C? Thanks in advance! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make A-B=C
Excel will do it for you. Click (and hold) the "fill handle" -- the little
black box on the bottom right of the cell. Drag it down as far as you want. When you release the mouse button, Excel will fill in the cells, adjusting the cell address appropriately. Regards, Fred. "Gundown64" wrote in message ... Do I have to go down each column and change the number to the corresponding row or is there an easier way? "Sheeloo" wrote: In C1 type the formula =A1-B1 then copy it down Col C in the cells you want the same calculation... for C2 it will change to =A2-B2 and so on... "Gundown64" wrote: I am trying to manage a few things I am selling and shipping off. In column a I have the price I sold it for. In column b I have the shipping price that was charged and in c I have the total profit made which is a-b, Is it possible to format them so it automatically subtracts from B from A so I can get C? Thanks in advance! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make A-B=C
After typing the formula in C1 press enter
Then selcect C1, press CTRL-C to copy , select the range you want similar formula and press CTRL-V to paste... you can also drag down the right-bottom corner of the cell C1 to copy it down... "Gundown64" wrote: Do I have to go down each column and change the number to the corresponding row or is there an easier way? "Sheeloo" wrote: In C1 type the formula =A1-B1 then copy it down Col C in the cells you want the same calculation... for C2 it will change to =A2-B2 and so on... "Gundown64" wrote: I am trying to manage a few things I am selling and shipping off. In column a I have the price I sold it for. In column b I have the shipping price that was charged and in c I have the total profit made which is a-b, Is it possible to format them so it automatically subtracts from B from A so I can get C? Thanks in advance! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make A-B=C
Worked. Thank you!
"Sheeloo" wrote: After typing the formula in C1 press enter Then selcect C1, press CTRL-C to copy , select the range you want similar formula and press CTRL-V to paste... you can also drag down the right-bottom corner of the cell C1 to copy it down... "Gundown64" wrote: Do I have to go down each column and change the number to the corresponding row or is there an easier way? "Sheeloo" wrote: In C1 type the formula =A1-B1 then copy it down Col C in the cells you want the same calculation... for C2 it will change to =A2-B2 and so on... "Gundown64" wrote: I am trying to manage a few things I am selling and shipping off. In column a I have the price I sold it for. In column b I have the shipping price that was charged and in c I have the total profit made which is a-b, Is it possible to format them so it automatically subtracts from B from A so I can get C? Thanks in advance! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make A-B=C
Welcome... Pl. click on 'Yes'
"Gundown64" wrote: Worked. Thank you! "Sheeloo" wrote: After typing the formula in C1 press enter Then selcect C1, press CTRL-C to copy , select the range you want similar formula and press CTRL-V to paste... you can also drag down the right-bottom corner of the cell C1 to copy it down... "Gundown64" wrote: Do I have to go down each column and change the number to the corresponding row or is there an easier way? "Sheeloo" wrote: In C1 type the formula =A1-B1 then copy it down Col C in the cells you want the same calculation... for C2 it will change to =A2-B2 and so on... "Gundown64" wrote: I am trying to manage a few things I am selling and shipping off. In column a I have the price I sold it for. In column b I have the shipping price that was charged and in c I have the total profit made which is a-b, Is it possible to format them so it automatically subtracts from B from A so I can get C? Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
| How do I make make comment format default? | Excel Discussion (Misc queries) | |||
| make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
| How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
| how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
Linear Mode
