+ Reply to Thread
Results 1 to 3 of 3

Formula to pull negative number

  1. #1
    Registered User
    Join Date
    11-28-2007
    Posts
    7

    Smile Formula to pull negative number

    Hello!

    Could someone please help me with this...

    Sheet 1 -- Cell B2 is formatted with a formula and the result turns out to be negative # (-2.)

    On Sheet 1, I want to set the parameter if cell B2 is a negative number, it will filter into cell D5. If it is not a negative number, nothing would filter into cell D5.

    Could someone give me some information on how to write the formula correctly for this.

    Thank you!

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    In D5, =IF(B2<0,B2,"")

  3. #3
    Registered User
    Join Date
    11-28-2007
    Posts
    7

    Thank you!

    Thank you!

+ 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