Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF Function (Excel 98)

    I have a problem with the IF function which I am sure will be very easy to fix by the experts. Attached worksheet with problem.
    Thanks in advance
    Novice
    Attached Files Attached Files

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

    Re: IF Function (Excel 98)

    Could you check your sample calculations? They don't seem to correspond with the table you provided.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF Function (Excel 98)

    Hans,
    Apologies for the error. Have attached the revised file (ver 98-2003) with correct formula.
    Cheers
    Novice
    Attached Files Attached Files

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

    Re: IF Function (Excel 98)

    Try this <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    =INDEX($J$9:$J$21,MATCH(F24,$I$9:$I$21))+(F24-LOOKUP(F24,I9:I21))*INDEX($F$9:$F$21,MATCH(F24,$I$ 9:$I$21)+1)*$C$10

    In the attached workbook, I have shown the intermediate steps (look at row 22)

    I arrive at a different answer for row 22.
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF Function (Excel 98)

    Hans,

    Thanks for the solution.

    Cheers
    Novice

Posting Permissions

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