+ Reply to Thread
Results 1 to 4 of 4

If Then result if answer is zero

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Dallas, TX
    MS-Off Ver
    2007
    Posts
    9

    If Then result if answer is zero

    I have the below formulas. They both work well when there's a positive or negative result. However, if the result in R6 is '0', a '1' is placed in both S6 and T6. What I would like is a '0' entered instead. Any ideas?

    Cell S6
    =IF(R6="","",IF(R6>0,0,1))

    Cell T6
    =IF(R3="","",IF(R3<0,0,1))

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: If Then result if answer is zero

    How about these:

    S6=IF(R6="","",IF(R6>=0,0,1))

    T6=IF(R3="","",IF(R3<=0,0,1))

  3. #3
    Registered User
    Join Date
    10-15-2012
    Location
    Dallas, TX
    MS-Off Ver
    2007
    Posts
    9

    Re: If Then result if answer is zero

    Yep, thanks.

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,872

    Re: If Then result if answer is zero

    You're welcome, happy to help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Replies: 2
    Last Post: 09-28-2017, 10:40 AM
  2. Variable Answer result
    By GordonP in forum Excel General
    Replies: 2
    Last Post: 03-25-2016, 02:37 PM
  3. Multi criteria search result to give unique answer
    By redpis in forum Excel General
    Replies: 2
    Last Post: 08-13-2013, 04:05 PM
  4. Replies: 9
    Last Post: 08-31-2011, 10:43 AM
  5. Can IF function result in its answer in a different cell?
    By donaldberends in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2010, 07:56 PM
  6. [SOLVED] If result is...Then text is the answer
    By heater in forum Excel General
    Replies: 2
    Last Post: 04-28-2006, 02:00 PM
  7. Formula help. Different result dependent on answer
    By martinco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-16-2005, 12:06 PM

Tags for this Thread

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