Forum Discussion

Jenine Montalbano's avatar
Jenine Montalbano
Copper Contributor
Apr 05, 2018

help with If formula please

Hello

Trying to insert a function that will look at ranges of numbers in 5 cells and return an answer of Cell1 * Cell 2:

 

Ex

 

 

1 - 10      20%

11-20      30%

21-30      40%

 

So if cell 1A equals 8, I want to return a simple answer that multiplies one cell by another.

Formulas and Functions
  • Jenine Montalbano's avatar
    Jenine Montalbano
    Copper Contributor
    Apr 05, 2018

    Probably should have been more clear:

     

    Example:

     

    1 - 10     20%

    11-20     30%

    21-30     40%

    31-40     50%

    41-50     60%

     

    I am trying to write formula that says look at Cell A1, find which range A1 falls into, then multiply Cell A1 by the % above

     

    thanks in advance

Resources