Forum Discussion

Jeremy Wilkerson's avatar
Jeremy Wilkerson
Copper Contributor
Apr 20, 2018
Solved

Formula help

I need help creating the formula for cell F3. Stating that if cell D3 is as follows: 1-5=0 6-8=3 9-11=4 12-14=6 15-17=8 18-19=10 20-21=12 22+=15 I'm sure its a simple formula but I have no i...
Excel Online
Formulas & Functions
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 20, 2018

Hi Jeremy,

 

You can use this formula in cell F3:

=LOOKUP(E3,A2:C9)

 

Please find the attached file.

 

Regards

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Apr 20, 2018

    Hi Jeremy,

     

    I've updated your workbook with this formula in cell F3:

    =IFERROR(LOOKUP(D3,'Points Assessed Conditions'!$A$2:$C$9),"")

    It refers to a table in a separate sheet called Points Assessed Conditions.

    I did that, to make it easy for you in the future if you want to update the conditions.

     

    If you don't want that, you can hardcode the conditions in the formula as follows:

    =IFERROR(LOOKUP(D3,{1,5,0;6,8,3;9,11,4;12,14,6;15,17,8;18,19,10;20,21,12;22,0,15}),"")

     

    Please find the attached file.

     

    Regards

    • Jeremy Wilkerson's avatar
      Jeremy Wilkerson
      Copper Contributor
      Apr 20, 2018

      SWEET, Thank you so much. I appreciate it

      • Jeremy Wilkerson's avatar
        Jeremy Wilkerson
        Copper Contributor
        Apr 26, 2018

        Can some one tell me the formula to get what is in cell E3 on the Violation Tracker which would be inputted from column A on the Preventable Accidents Tab and then have the points that are assessed to that number added into the formula for cell G on the Violation Tracker Tab?  I want the points assessed to include the points from the points assessed conditions and preventable accidents if that is even possible. Thanks

Resources