Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding & Subtracting formula for a Cell
I wish to create a form to track receipts to and issues from a store.
Very simply like this Column A Column B Column C Receipts Add Issues Subtract Stock Remaining Not being very conversant with excel could any body suggest a formula that will add in column C a number entered in column A, and subtract in column C a number is entered in column B. Your help is appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding & Subtracting formula for a Cell
With he headers in Row 1 enter in cell C2:
=IF(COUNT(A2:B2)0,SUM($A$2:A2)-SUM($B$2:B2),"") Nothing will show until you enter something in Column A or Column B Hover the cursor over the bottom right-hand corner of the cell and the cursor will change into black cross-hairs. (Make sure that it is not a four headed arrow cursor which will capture and move the cell.) When the cross-hairs are showing, left-click and drag down the column and XL will copy the formula down the column. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "ChrisP" wrote in message ... I wish to create a form to track receipts to and issues from a store. Very simply like this Column A Column B Column C Receipts Add Issues Subtract Stock Remaining Not being very conversant with excel could any body suggest a formula that will add in column C a number entered in column A, and subtract in column C a number is entered in column B. Your help is appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding & Subtracting formula for a Cell
I wish to create a form to track receipts to and issues from a store.
Very simply like this Column A Column B Column C Receipts Add Issues Subtract Stock Remaining Not being very conversant with excel could any body suggest a formula that will add in column C a number entered in column A, and subtract in column C a number is entered in column B. Here's one way. Put column headers in row 1; for example, "Receipts" ..... Put the opening stock balance in C2. In C3 put: =C2+A3-B3 If you want a cleaner look, use this instead: =IF(COUNT(A3:B3)=0,"",C2+A3-B3) Then copy C3 downward for as many rows as you'll be using. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding & Subtracting formula for a Cell
ChrisP;
Sandy's is a little involved, but is certainly one way of doint things. Try this instead =IF(OR(A30,B30),A3-B3,"") If you don't mind having a 0 in column C then just enter; =a3-b3 God Bless Frank Pytel "ChrisP" wrote: I wish to create a form to track receipts to and issues from a store. Very simply like this Column A Column B Column C Receipts Add Issues Subtract Stock Remaining Not being very conversant with excel could any body suggest a formula that will add in column C a number entered in column A, and subtract in column C a number is entered in column B. Your help is appreciated. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding & Subtracting formula for a Cell
"Frank Pytel" wrote in message
... =IF(OR(A30,B30),A3-B3,"") That won't subtract from Column C -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Frank Pytel" wrote in message ... ChrisP; Sandy's is a little involved, but is certainly one way of doint things. Try this instead =IF(OR(A30,B30),A3-B3,"") If you don't mind having a 0 in column C then just enter; =a3-b3 God Bless Frank Pytel "ChrisP" wrote: I wish to create a form to track receipts to and issues from a store. Very simply like this Column A Column B Column C Receipts Add Issues Subtract Stock Remaining Not being very conversant with excel could any body suggest a formula that will add in column C a number entered in column A, and subtract in column C a number is entered in column B. Your help is appreciated. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding & Subtracting formula for a Cell
Many thanks all for replying. I can go ahead now with confidence.
Kind regards, ChrisP "Frank Pytel" wrote: ChrisP; Sandy's is a little involved, but is certainly one way of doint things. Try this instead =IF(OR(A30,B30),A3-B3,"") If you don't mind having a 0 in column C then just enter; =a3-b3 God Bless Frank Pytel "ChrisP" wrote: I wish to create a form to track receipts to and issues from a store. Very simply like this Column A Column B Column C Receipts Add Issues Subtract Stock Remaining Not being very conversant with excel could any body suggest a formula that will add in column C a number entered in column A, and subtract in column C a number is entered in column B. Your help is appreciated. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding & Subtracting formula for a Cell
Hi Frank,
Only the OP will know for sure but I took it the the OP's first language was not English and Chris P meant: "subtract in column C a number [that] is entered in column B." ie The running tota is in Column C, entries in Column A are added to C and issues are subtracted from C. But like you say it won't be the first time I misread a post - I specialise in it! -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Frank Pytel" wrote in message ... Sandy I am sorry. I may be reading this wrong. "subtract in column C a number is entered in column B." I am understanding that Column B is to be subtracted from Column C. Hey, Won't be the first time I'm wrong and it won't be the last. God Bless Frank Pytel "Sandy Mann" wrote: "Frank Pytel" wrote in message ... =IF(OR(A30,B30),A3-B3,"") That won't subtract from Column C -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Frank Pytel" wrote in message ... ChrisP; Sandy's is a little involved, but is certainly one way of doint things. Try this instead =IF(OR(A30,B30),A3-B3,"") If you don't mind having a 0 in column C then just enter; =a3-b3 God Bless Frank Pytel "ChrisP" wrote: I wish to create a form to track receipts to and issues from a store. Very simply like this Column A Column B Column C Receipts Add Issues Subtract Stock Remaining Not being very conversant with excel could any body suggest a formula that will add in column C a number entered in column A, and subtract in column C a number is entered in column B. Your help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i do adding and subtracting on excel | New Users to Excel | |||
adding and subtracting using vb code | Excel Discussion (Misc queries) | |||
adding and subtracting columns | Excel Worksheet Functions | |||
formula for adding / subtracting two columns . | New Users to Excel | |||
Adding Subtracting Time Formula-Horse Racing | Excel Discussion (Misc queries) |