Results 1 to 5 of 5

If Statements to calculate negative numbers

Threaded View

  1. #1
    Registered User
    Join Date
    12-20-2010
    Location
    Cambridge, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    89

    If Statements to calculate negative numbers

    Hello Forum,

    I'm hoping someone can help me out with what I believe is a simple formula that I cannot seem to get to work.

    In column C is the amount that I will charge a customer.
    In column D is the amount the customer paid me.
    In column E is the balance owing.

    A simple formula in cell E2 to figure out the balance owing is this:
    (E1+C2-D2)

    The issue I have is this :
    If my customer pays me more than they need to (we work on large projects here and they like to "pre pay" ahead of time), I need it to add their payment to the balance.

    I've attached an example.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1