+ Reply to Thread
Results 1 to 4 of 4

If a cell equals a negative number

  1. 07-21-2011, 05:09 PM #1
    rphan
    rphan is offline
    Registered User
    Join Date
    07-18-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    22

    If a cell equals a negative number

    If a cell equals negative number i want it to show up 0

    so my formula so far is

    =-(200-c3)
    =-80

    and I want it to show up 0
    Reply With QuoteRegister To Reply
  2. 07-21-2011, 05:15 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,719

    Re: If a cell equals a negative number

    What do you want to appear if the number is zero or positive?
    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
    Reply With QuoteRegister To Reply
  3. 07-21-2011, 05:15 PM #3
    Colin Legg
    Colin Legg is offline
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    365
    Posts
    1,256

    Re: If a cell equals a negative number

    =max(0,c3-200)
    Hope that helps,

    Colin

    RAD Excel Blog
    Reply With QuoteRegister To Reply
  4. 07-21-2011, 05:17 PM #4
    rphan
    rphan is offline
    Registered User
    Join Date
    07-18-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: If a cell equals a negative number

    nvm i solved it thanks
    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)

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