Adding & Subtracting formula for a Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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.
Click to expand...

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.
 
ChrisP;

Sandy's is a little involved, but is certainly one way of doint things. Try
this instead

=IF(OR(A3>0,B3>0),A3-B3,"")

If you don't mind having a 0 in column C then just enter;

=a3-b3

God Bless

Frank Pytel
 
=IF(OR(A3>0,B3>0),A3-B3,"")
Click to expand...

That won't subtract from Column C
--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Many thanks all for replying. I can go ahead now with confidence.
Kind regards,
ChrisP
 
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
 
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."
Click to expand...

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top