+ Reply to Thread
Results 1 to 4 of 4

IF/Then formula not working properly against drop-down box of options

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    minnesota
    MS-Off Ver
    Excel 2010
    Posts
    5

    IF/Then formula not working properly against drop-down box of options

    Column J row 6 is a drop-down box of options including: 0,1,2,3+
    Column K row 6 is an If/Then as follows: =IF(J6="0",0,IF(J6="1",0.05,IF(J6="2",0.1,IF(J6="3+",0.15,))))

    Problem: K returns a zero for 0,1,2 and a .15 for a 3. So only the 3 is computing correctly but the others are not. If/Then appears to be written correctly. Any ideas on the problem?? Thanks!

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: IF/Then formula not working properly against drop-down box of options

    Try to remove the quotation"" around the number:
    =IF(J6=0,0,IF(J6=1,0.05,IF(J6=2,0.1,IF(J6="3+",0.15,))))
    Quang PT

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: IF/Then formula not working properly against drop-down box of options

    Or another option:
    =IF(TEXT(J6,0)="0",0,IF(TEXT(J6,0)="1",0.05,IF(TEXT(J6,0)="2",0.1,IF(J6="3+",0.15,))))

  4. #4
    Registered User
    Join Date
    04-24-2013
    Location
    minnesota
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: IF/Then formula not working properly against drop-down box of options

    Thanks! This worked. Appreciate your response!

+ 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