+ Reply to Thread
Results 1 to 3 of 3

Nesting if statements

Hybrid View

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    United Kingdom
    MS-Off Ver
    Mac 2011
    Posts
    34

    Nesting if statements

    I am trying to nest 6 if statements, i want the statements to define the certain upper and lower boundaries to and to relate this to a letter
    i have a total range of M31:M147 to apply this to but for this i am just gonna use M32. value of M32=2.37E-03
    The rules i want to apply are:
    A-<10E-6
    B- >=10E-6 to <10E-4
    C- >=10E-4 to <10E-3
    D- >=10E-3 to <10E-2
    E- >=10E-2 to <10E-1
    F->=10E-1

    the if statement i have written is:

    =IF(M32<10E-6,"A",IF(10E-6<=M32<10E-4,"B",IF(10E-4<=M32<10E-3,"C",IF(10E-3<=M32<10E-2,"D",IF(10E-2<=M32<10E-1,"E",IF(M32>=10E-1,"F"))))))

    but this wont come back with a letter, it always just comes back with "FALSE", not "D" as i would hope.

    Thanks for the help.
    Last edited by will.girling; 11-22-2013 at 07:07 AM.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Nesting if statements

    You can't write
    10E-6<=M32<10E-4
    it needs to be
    and(M32>=10E-6,M32<10E-4)

  3. #3
    Registered User
    Join Date
    11-13-2013
    Location
    United Kingdom
    MS-Off Ver
    Mac 2011
    Posts
    34

    Re: Nesting if statements

    Cheers mate, works fine now.

+ 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. [SOLVED] Nesting IF statements?
    By markthehousebuyer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-14-2013, 01:59 PM
  2. Nesting IF/AND/Or statements
    By ivwshane in forum Excel General
    Replies: 2
    Last Post: 03-22-2009, 05:17 PM
  3. Nesting If statements
    By Smitty14 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2008, 10:47 AM
  4. Nesting IF statements
    By penny in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2007, 04:02 PM
  5. Nesting If statements
    By RGPH in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-05-2007, 11:05 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