Adding & Subtracting formula for a Cell

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

 

[Sandy Mann]

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

 

[MyVeryOwnSelf]

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.

 

[Guest]

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

 

[Sandy Mann]

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

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

 

[Guest]

Many thanks all for replying. I can go ahead now with confidence.
Kind regards,
ChrisP

 

[Guest]

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]

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

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