Results 1 to 6 of 6

Need a formula to equate values of two columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-01-2014
    Location
    RIX
    MS-Off Ver
    Excel 2003; 2007
    Posts
    114

    Need a formula to equate values of two columns

    Subt_Col_EX_Forum.zipHi!

    There are two columns with different values.

    Column A negative values; Column B possitive.

    The aim: to plus the values from column B with values from column A as mutch as it's possible, observing two constraints:

    1) Column A values cannot go above 0;

    2) Column B values cannot go under 0

    See the file attached.

    Thanks in advance!
    Last edited by Arty_1; 11-25-2014 at 07:42 AM.
    Regards

    Arty

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-06-2012, 12:24 AM
  2. How do I equate stats when negatives are involved?
    By Excelatexcel in forum Excel General
    Replies: 6
    Last Post: 09-23-2011, 10:10 PM
  3. Replies: 3
    Last Post: 03-16-2010, 01:26 PM
  4. [SOLVED] equate Text values to numbers for addition.
    By all4excel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2007, 12:14 PM
  5. Replies: 3
    Last Post: 01-22-2006, 01:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1