Multiplying a number betwee ranges in an IF statement

  • If cell A2 is between 0-2 multiply cell B2 by 0.0692, if cell A2 is between 3-5 multiply cell B2 times 0.0768, if Cell A2 is between 6-10 multiply cell B2 times 0.0884, if cell A2 is between 11-15 multiply cell B2 times 0.1000, if cell A2 is >16 multiply cell B2 times 0.1077.


    Can some one help?

  • Re: Multiplying a number betwee ranges in an IF statement


    Try:


    [COLOR="#0000FF"]=B2*LOOKUP(A2,{0,3,6,11,17},{0.0692,0.0768,0.0884,0.100,0.1077})[/COLOR]

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


    MS Excel MVP 2010-2016