+ Reply to Thread
Results 1 to 3 of 3

Formula to total amounts in different cells

  1. 09-03-2014, 07:53 AM #1
    Treecko
    Treecko is offline
    Registered User
    Join Date
    10-03-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003
    Posts
    67

    Formula to total amounts in different cells

    Hi all
    I'm looking for a formula that if the number is positive it will go to one cell and if the number is negative it will go to another cell. Any help as always would be appreciated.
    I upload a sample work sheet.
    Thanks

    Totalling in Specific Cell.xlsx
    Reply With QuoteRegister To Reply
  2. 09-03-2014, 07:59 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula to total amounts in different cells

    N20=if($J20>=0,$J20,"")

    O20=if($J20<=0,$J20,"")

    and both drag down
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 09-03-2014, 08:00 AM #3
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Formula to total amounts in different cells

    Hi,

    try this

    Punnam
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need formula to sum every 12 cells to get yearly amounts
    By bxk006 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2014, 03:36 PM
  2. [SOLVED] IF Formula to take name of company and compare amounts to return a difference in amounts
    By AAL in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2014, 09:56 PM
  3. Formula to total all amounts in a column adjacent to a particular name
    By nattyann89 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-28-2013, 11:19 AM
  4. need formula help for only cells with amounts
    By renebarton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2012, 10:44 AM
  5. Need help populating two cells with different amounts from one given total.
    By avidcat in forum Excel General
    Replies: 5
    Last Post: 11-13-2008, 12:20 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1