+ Reply to Thread
Results 1 to 3 of 3

Need a formula for an amount in a column that is just 2 columns subracted from one another

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Conroe, TX
    MS-Off Ver
    Excel 2007
    Posts
    69

    Need a formula for an amount in a column that is just 2 columns subracted from one another

    I am hoping that someone can help me. Upon learning a little, I have figured a little out, but still need help.
    I need column M to show just the balance of rent due. I inserted a formula that shows =G19-H19 and got the $0 balance that I needed for that row, as the rent was paid in full.
    On line 20, I tried to insert a formula that would show again, what the amount due was by inserting a formula of =(G20-H20,0), but that didn't work. Since the rent owed amount is $0 on that line and the payments were actually put to other cells, I need the balance of the rent owed to once again say $0
    What am I doing wrong?
    Thank you to anyone that can help me!!
    I have attached the worksheet
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-12-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    230

    Re: Need a formula for an amount in a column that is just 2 columns subracted from one ano

    I'm pretty sure I know what you're trying to do. Does this help?

    =IF(H20=0,0,G20-H20)

  3. #3
    Registered User
    Join Date
    02-27-2013
    Location
    Conroe, TX
    MS-Off Ver
    Excel 2007
    Posts
    69

    Re: Need a formula for an amount in a column that is just 2 columns subracted from one ano

    You are wonderful!! Thank you so much! I have been working on this for two weeks and couldn't figure it out. I have some other things that I need to do with this worksheet, but this is exactly what I needed for this question.

+ Reply to Thread

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