Results 1 to 11 of 11

Excel 2008 : RESOLVED Configuring Nested IF Logic

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2010
    Location
    Dallas, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    13

    Unhappy RESOLVED Configuring Nested IF Logic

    I am trying to generate an IF statement that will take the data in cell D7 and if it is more than 4 the result is 15, if it is between 2 and 4 years, the result is 10, if it is between 1 and 2 years, the result is 5, if it is less than 1, the result is 0.

    What I have is =IF(AND(B7="FT",D7>=4),15,IF(OR(B7="FT",D7>=2<=4),10,IF(OR(B7="FT",D7>=1<=2),5,
    IF(OR(B7="FT",D7=0),0)))

    The result is always 10, even if the cell is 4 or greater.

    What have I got that is wrong and can you help?

    Excel 2010 on the Windows Partition
    Excel 2011 on the Mac Partition.
    Last edited by baraktorvan; 11-27-2010 at 09:39 PM.

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