+ Reply to Thread
Results 1 to 3 of 3

formula to return amount total if credit and blank if debt

  1. #1
    Registered User
    Join Date
    03-31-2019
    Location
    Christchurch
    MS-Off Ver
    excel 10
    Posts
    1

    formula to return amount total if credit and blank if debt

    I have a spread sheet where I have two cells that total data from other cells.
    I need a formula to put in the cell following the calculation that will print the amount if it is a credit but not print it if it is a debt.
    Conversely I need the opposite in another cell.
    Can someone please help me. I am learning with excel and formulas.
    Thanks

    Title changed by Moderator FlameRetired.
    Last edited by FlameRetired; 03-31-2019 at 10:00 PM. Reason: Thread title change

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: formula to return amount total if credit and blank if debt

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

    Since you are new to the forum as a courtesy I have changed the title for you this time.

    Postings may continue.
    Dave

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: formula to return amount total if credit and blank if debt

    Perhaps something like...
    =if(balance-cell>0,amount,"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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