Multiple And Statements

  • Hi All


    Any thoughts on a formula that gives a different output for a range of numbers.


    i.e.


    A1 contains a value from 0 to 1000

    A formula in A2 should follow the following scenario:


    If the number is below 200 then show a response of "Low"

    If the number is equal to or greater than 200 but below 400 then show a response of "Medium"

    If the number is equal to or greater than 400 but below 800 then show a response of "Medium High"

    If the number is equal to or greater than 800 and below 1000 then show a response of "High"

    If the number is equal to or greater than 1000 then show "Very High"


    Any help is much appreciated


    Thank you

  • What if it is equal to 200 or 400 or 800 or 1000? You haven't specified.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • HI NBVC


    Thanks for the repsonse


    Sorry, I though I was clear on that.


    If the number is below 200 then show a response of "Low"

    If the number is equal to or greater than 200 but below 400 then show a response of "Medium"

    If the number is equal to or greater than 400 but below 800 then show a response of "Medium High"

    If the number is equal to or greater than 800 and below 1000 then show a response of "High"

    If the number is equal to or greater than 1000 then show "Very High"


    Thank you

  • In that case try:


    =LOOKUP(A1,{0,200,400,800,1000},{"Low","Medium","Medium High","High","Very High"})

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

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