+ Reply to Thread
Results 1 to 4 of 4

If formula equals negative number, make it blank.

  1. #1
    Registered User
    Join Date
    02-15-2007
    Posts
    14

    If formula equals negative number, make it blank.

    Here's my formula... =SUM(S7)-T5

    If that number is less than -100, I want it to show as blank.

    Any help?

    Right now, I'm trying to accomplish this by making a conditional format...meaning when my cell equals less than -100 I make the cell color and font the same (so it looks blank, but its not). When I print it, it still shows the negative value.


    Thanks.

  2. #2
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    Re: If formula equals negative number, make it blank.

    Double Evaluating

    =IF(SUM(S7,-T5)<-100,"",SUM(S7,-T5))

    Alternatively leave as is, dispense with Conditional Formatting and use a Custom Format on the cell of: [<-100]"";[>=0]#,##0.00;[Red]#,##0.00
    adjust formats to suit
    Last edited by DonkeyOte; 10-20-2009 at 03:54 AM.

  3. #3
    Registered User
    Join Date
    02-15-2007
    Posts
    14

    Re: If formula equals negative number, make it blank.

    Seems like I'm close... Is this right?

    =SUM(S7)-T5=IF(SUM(S7,-T5)<-100,"",SUM(S7,-T5))

    Right now its responding with a FALSE.

  4. #4
    Registered User
    Join Date
    02-15-2007
    Posts
    14

    Re: If formula equals negative number, make it blank.

    I GOT IT! Custom formating did it.

    Thanks guys.

+ 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