+ Reply to Thread
Results 1 to 4 of 4

Formula to get negative to positive value and positive to zero

  1. #1
    Registered User
    Join Date
    04-18-2014
    Location
    Vadodara
    MS-Off Ver
    Excel 2007
    Posts
    1

    Formula to get negative to positive value and positive to zero

    I am having trouble with the formula,

    I am working on a sheet where i need to calculate LWP ( leave without pay ). Now i need a formula where opening balance + Leave credited - Leave availed = some value ( positive or negative).

    If its negative

    2 + 2 - 5 = -1 ( hence leave without pay is 1 so i want it positive 1 not negative)

    if the person has not taken leave

    2+2-0= 4 ( hence leave without pay is 0, hence i need it 0)

    Could you please suggest any formula where i can get this in LWP column.

    Thanks
    Last edited by Nikunj Morjaria; 04-18-2014 at 08:08 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,930

    Re: Required a formula

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,372

    Re: Formula to get negative to positive value and positive to zero

    I don't understand your calculations. How can 2+2-5=1? How can 2+2-0=4?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formula to get negative to positive value and positive to zero

    maybe
    =-MIN(A1+B1-C1,0)
    Last edited by martindwilson; 04-18-2014 at 08:34 AM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula required to hide results from another cell formula
    By 917 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2013, 12:12 AM
  2. Formula required
    By SAMEEP in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-06-2012, 03:02 AM
  3. Formula required
    By OBF in forum Excel General
    Replies: 1
    Last Post: 06-17-2010, 11:10 PM
  4. Help with formula required
    By jonrayworth in forum Excel General
    Replies: 1
    Last Post: 01-12-2009, 12:26 PM
  5. IF Formula Help Required
    By FM1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2008, 10:14 PM

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