+ Reply to Thread
Results 1 to 6 of 6

Don't want the field to show FALSE on an if/then formula

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    3

    Don't want the field to show FALSE on an if/then formula

    We are using the following formula in a spreadsheet:

    =IF(Y2>799999,".35",IF(Y2>500000,".30",IF(Y2>0,".25")))

    I want to be able to format the entire column, but not have the blank fields show "FALSE". I want the fields to just be blank if there isn't anything in the "Y" field.

    Any help would be appreciated.

    Thanks!

  2. #2
    Registered User
    Join Date
    10-02-2012
    Location
    Baku
    MS-Off Ver
    Excel 2010
    Posts
    273

    Re: Don't want the field to show FALSE on an if/then formula

    =if(y2>799999,".35",if(y2>500000,".30",if(y2>0,".25","")))

  3. #3
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Don't want the field to show FALSE on an if/then formula

    YOU CAN CHANGE YOUR FORMULA TO THIS:
    =IF(Y2>799999,0.35,IF(Y2>500000,0.3,IF(Y2>0,0.25,"")))

    OR EVEN USE SOMETHING LIKE THIS:
    =IFERROR(LOOKUP(Y2,{1,500001,800000},{.25,.30,.35}),"")

    - Moo

  4. #4
    Registered User
    Join Date
    01-24-2013
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Don't want the field to show FALSE on an if/then formula

    That didn't work......when I put your formula in, it made all the fields go to .30. Any thing else I can try?

  5. #5
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Don't want the field to show FALSE on an if/then formula

    I tested both eisayew's and my solutions, and they all work just fine. Not sure why your result is different, unless all of your data falls between 500001 and 799999

    - Moo

  6. #6
    Registered User
    Join Date
    01-24-2013
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Don't want the field to show FALSE on an if/then formula

    I will try it again.....must be user error. :o) Thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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