Formula to calculate result based on range.

  • I'm new to using the "if" function so I apologize for the amateur question however I've been racking my brain on this one.

    I have a scorecard that looks something like this:

    90% or greater=3

    I need the "cell" to react accordingly and I'm lost. Any help would be greatly appreciated. Thanks.

  • Re: Formula to calculate result based on range.


    The best way would be to use the VLOOKUP function.

    Create a table of the percentages and thier values.
    Column A Column B
    0% 0
    70% 1
    80% 2
    90% 3

    The vlookup would be =VLOOKUP(D1,$A$1:$B$4,2) where D1 is the percentage you are looking for.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!