Results 1 to 9 of 9
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Add to IF formula (Excel 2002)

    Hi

    I need to add this formula below IF(J20)="Solids"),"" (else run the formula below)



    =IF(ISNA(VLOOKUP(H20,Manufacturer,2,0)),"",VLOOKUP (H20,Manufacturer,2,0))


    Many Thanks Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add to IF formula (Excel 2002)

    How about

    =IF(J20="Solids","",IF(ISNA(VLOOKUP(H20,Manufactur er,2,0)),"",VLOOKUP(H20,Manufacturer,2,0)))

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Add to IF formula (Excel 2002)

    Hi Hans

    If I was a man of any substance, you would definatley be in my will.

    Most grateful for your reply.


    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add to IF formula (Excel 2002)

    Braddy,

    I found this info on the web a long while back. It takes you through a logical step by step to building a big nested formula. It is VERY hand if you struggle building these types of formulas!

    Take a look at this doc!
    Regards,
    Rudi

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Add to IF formula (Excel 2002)

    Hi Rudi

    Thanks for that, I will peruse the document and see if it helps.


    Bradd7
    If you are a fool at forty, you will always be a fool

  6. #6
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add to IF formula (Excel 2002)

    Nice one, Rudi.
    I often find it helps in understanding formulas (not just big 'uns) to use named ranges where possible, startdate<1990, that sort of thing, and sometimes it helps to 'build' the formula in the idiots' guide box you get by clicking on the = sign in the formula bar.
    Justathort

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add to IF formula (Excel 2002)

    Besides breaking a formula up individually and then connecting them all up as in the attachment, I also find the Function Palette of Excel is superb, whether you are creating a new nested formula or editing an existing one! If you have never noticed this before, try this example:
    1. Create a small nested formula in a cell :
    eg. Or copy this one to cell A1 :
    =IF(ISERROR(VLOOKUP(B1,C1:E10,2,FALSE))>5,SUM(G1:G 10),AVERAGE(H1:H10))
    2. Select the cell containing the formula and click on the (fx) Paste Function toolbar button.
    3. This activates the palette and displays the formula in the formula bar (below the toolbars)
    4. Now...if you click on the NAME of the functions (in the formula bar), it will switch between the various palettes and allow you to check and modify the arguments in the individual functions. The palette also shows where errors will occur, and shows the final result before you choose OK.

    I find this extremely handy!
    Regards,
    Rudi

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add to IF formula (Excel 2002)

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> You mentioned the source of this information in <post#=402058>post 402058</post#>

  9. #9
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add to IF formula (Excel 2002)

    Thanx Hans...it's important to give credit to persons responsible for good information. Thanks for the link!
    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •