+ Reply to Thread
Results 1 to 6 of 6

Easy way:If Statement

  1. #1
    Registered User
    Join Date
    01-10-2008
    Posts
    3

    Easy way:If Statement

    can someone help with this "if statement"?
    I am new on this.....I cannot get it to work
    is there any other way to do this?

    =IF(AND(A12>71012,A12<71025),D12*0.265,IF(AND(A12>76001,A12<76010),D12*0.315,IF(A12=76001,D12*0.185,IF(AND(A12>74009,A12<74018),D12*0.475,IF(AND(A12>75002,A12<75014),D12*0.42,IF(A12=75001,D12*0.42,IF(A12=75002,D12*0.27,IF(AND(A12>72011,A12<72015),D12*0.302,IF(AND(A12>72014,A12<72018),D12*0.252,IF(A12=72011,D12*0.252,IF(A12=72010,D12*0.202," ")))))))))))

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    To many IF's

    http://www.cpearson.com/excel/nested.htm
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    01-10-2008
    Posts
    3

    If Statement

    Thank you for your help
    I tried to use nested page.

    but:
    =if(onetosix,onetosix,seventotwelve)

    I got to this point. Naming my first formula "onetosix" works fine but "seventotwelve" wont work. I noticed that when I go back to my formula it deletes my "if" statements. so it says "=and( " instead of =if(and(...." .
    any idea what's going on?

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Does this vlookup table help - see attached

    and also this link

    http://www.contextures.com/xlFunctions02.html
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-10-2008
    Posts
    3
    Thank You very much. Problem solved

  6. #6
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Glad to hear it - thanks for the feedback

+ 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