Results 1 to 4 of 4

Thread: Formula help

  1. #1

    Formula help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Maybe someone can help. I have the below formula

    =IF(G4=A3,B3,IF(G4=A4,B4,IF(G4=A5,B5,IF(G4=A6,B6,IF(G4=A7,B7,IF(G4=A8,B8))))))

    However, I also have a formula in cell G4 which reads I4/F4. My result is showing False. If I just type in the result, and not have the I4/F4 formula it does the calculation. Hope I explained that well. I am confusing my self. Thanks for your help.

  2. #2
    hmm...tried to reply but didn't happen...hope i don't reply twice by mistake


    Can you attach the sheet? I would guess that your result I4/F4 is evaluating to something close to a value and "appears" to be equal to one of those values based on the number of decimal points you are showing. The way you have written the formula would produce a "FALSE" if that value (I4/F4) didn't EXACTLY equal one of the values from A4 to A8 (your last IF statement has no instruction for the FALSE case).

    For instance if,I4 = 9 and F4 =2.99, then I4/F4 would look like 3 or 3.0 but would not be "equal to" 3 or 3.0.

    But, w/o seeing the sheet, not sure what you are trying to do exactly. Are you trying to set up a range of values to produce a grade? Like A3 = 100, A4 = 90, ... B3="A", B4="B"??
    Last edited by snelmica; 2011-09-09 at 07:26 PM.

  3. #3
    Book1.xls

    Hope that worked. Thanks for your help.

  4. #4
    Use

    =INDEX($B$1:$B$6,MATCH(ROUND(G1,1),$A$1:$A$6,0))

Posting Permissions

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