Thread
:
Adding & Subtracting formula for a Cell
View Single Post
#
5
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
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.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann