+ Reply to Thread
Results 1 to 3 of 3

Need Help preventing columns from going negative.

  1. #1
    Forum Contributor
    Join Date
    06-30-2008
    Location
    PSL, FL
    Posts
    271

    Need Help preventing columns from going negative.

    If you open the workbook I gave you on the sheet MLB OVERALL you will have two columns TOT SAVINGS (T) and TOT DEP (X) those together = a savings account and need #1 to combine them as one value.


    #2 I need to prevent that value from going negative.

    I need so if the value goes negative it gets subtracted from my bankroll which is column (R).


    please see my attached workbook
    Matt
    Attached Files Attached Files

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Need Help preventing columns from going negative.

    Hello
    can you try using abs function

    =abs(yourformulahere)
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Contributor
    Join Date
    06-30-2008
    Location
    PSL, FL
    Posts
    271

    Re: Need Help preventing columns from going negative.

    Anybody that can help me please contact me at my email or by private message.

    Completion of this problem and I will pay 50 via paypal.

+ 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