+ Reply to Thread
Results 1 to 5 of 5

dispalying a zero where there is a minus value

  1. #1
    Registered User
    Join Date
    04-09-2015
    Location
    derby england
    MS-Off Ver
    2007
    Posts
    33

    dispalying a zero where there is a minus value

    Hello
    I need some help with a minus value we are getting
    In column Q, we will like this value to show as 0 if it's a minus value.

    example in column Q, cell Q3 shows as -4.80, but we need any vales on column Q to display a zero if its a minus value
    cell P3 value is 25.2 and cell Q2 value is 30
    Q3=(P3-$Q$2)

    as the sheet attached.
    thank you
    Veer
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: dispalying a zero where there is a minus value

    Put this in Q3 and drag down

    =IF((P3-$Q$2)<=0,0,(P3-$Q$2))
    Cheers!
    Deep Dave

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: dispalying a zero where there is a minus value

    or try this...
    =MAX(0,P3-$Q$2)

  4. #4
    Registered User
    Join Date
    04-09-2015
    Location
    derby england
    MS-Off Ver
    2007
    Posts
    33

    Re: dispalying a zero where there is a minus value

    thank you very much , both options worked perfectly
    veer

  5. #5
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: dispalying a zero where there is a minus value

    You are welcome!

+ 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. [SOLVED] Swits leading minus and put minus infront of numbers without macro
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2015, 11:40 AM
  2. [SOLVED] How to get the correct (minus) answer for a minus raised to a power
    By enginezzz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 08:44 PM
  3. [SOLVED] I neeed help on changing a minus figure so it does not show a minus
    By Kirstg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-24-2012, 11:44 AM
  4. CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
    By Socal Analyst looking for help in forum Excel General
    Replies: 2
    Last Post: 05-12-2006, 02:20 PM
  5. Dispalying negative times
    By Francis Brown in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2005, 10:15 PM
  6. Value Minus Value = ???
    By Emzicle in forum Excel General
    Replies: 9
    Last Post: 08-23-2005, 03:22 PM
  7. how do you count a column minus dupicates minus blanks.
    By notEXCELing in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2005, 08:48 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