+ Reply to Thread
Results 1 to 4 of 4

how do i nest more than 15 " if " functions in a formula

  1. #1
    HARSH BAHAL
    Guest

    how do i nest more than 15 " if " functions in a formula

    Pl. help.

  2. #2
    Alan
    Guest

    Re: how do i nest more than 15 " if " functions in a formula

    You cant, seven is the limit. You need to rethink and use some kind of
    LOOKUP,
    Regards,
    Alan.
    "HARSH BAHAL" <HARSH [email protected]> wrote in message
    news:[email protected]...
    > Pl. help.




  3. #3
    Max
    Guest

    Re: how do i nest more than 15 " if " functions in a formula

    Re: how do i nest more than 15 " if " functions in a formula
    Maybe also take a look at Chip's page:
    http://www.cpearson.com/excel/nested.htm
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1° 22' N 103° 45' E
    xdemechanik <at>yahoo<dot>com
    ----

    "HARSH BAHAL" <HARSH [email protected]> wrote in message
    news:[email protected]...
    > Pl. help.




  4. #4
    Registered User
    Join Date
    05-20-2005
    Posts
    9
    I would suggest you to go to Visual Basic Editor and build a custom function for it. Something like this
    Press Alt +F11, insert module
    Type in:

    Function test(criteria)
    If (criteria = "Good") Then test = 1
    If (criteria = "Excellent") Then test = 2
    if
    if
    if
    if
    if
    if
    if

    End function.
    Go back to Excel, type in =test("Good") and see the result

+ Reply to Thread

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