 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Formula Problem for Newbie - Please!
I have 4 columns : A1 is date; B1 is Advance; C1 is Deposit and D1 is Total... How do I do this formula so that D1 shows the total. The total column will be in a negative because the Advances are more than the Deposits but I think if I just insert the Advance with a - sign, this should work. Have spent an hour trying to figure out this simple thing, so finally decided to ask for help. Thanks! If the Advance are positive values use =C1-B1 Otherwise =C1+B1 best wishes  SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email >I have 4 columns : A1 is date; B1 is Advance; C1 is Deposit and D1 is >Total... [quoted text clipped - 4 lines] > to ask for help. > Thanks! Bernard: Where do I insert this formula and what do I highlight? I went to D and put in =C1-B1 and nothing happens...sorry to be so ignorant. > If the Advance are positive values use =C1-B1 > Otherwise =C1+B1 [quoted text clipped - 7 lines] >> decided to ask for help. >> Thanks! Nothing happened? You typed =C1-B1 in D1 and there were numbers in B1 and C1? What did you see? Did you see the formula? Or did you see 0? I will send you a sample file and you can tell me what you see. best wishes SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email > Bernard: > [quoted text clipped - 12 lines] >>> finally decided to ask for help. >>> Thanks! Problem solved by private email SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email > Nothing happened? You typed =C1-B1 in D1 and there were numbers in B1 and > C1? [quoted text clipped - 17 lines] >>>> finally decided to ask for help. >>>> Thanks!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.