Forum Discussion

dangercoy's avatar
dangercoy
Copper Contributor
Mar 19, 2020
Solved

Formula needed to choose from 5 options and multiply

My data is as seen above. 

 

I need the numbers in E to be multiplied by the percentage in I and then added together. This is predicated by the value of the number in E. 

 

Example: E1 is $30.99. This falls into the category of H9 so i need $30.99 to be multiplied by 20%. Then, i need the sum of $6.20 to be added to the $30.99 and dropped into F1. I'll need this to be repeated for all rows. There must be an easy way to do this. I'm looking too far into it. Played around with some IF functions but i can't get it. 

  • Your formula in F1 could be:
    =E1*(1+LOOKUP(E1,
    {0,3,10,15,20},
    {0.6,0.55,0.4,0.3,0.2}))

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Your formula in F1 could be:
    =E1*(1+LOOKUP(E1,
    {0,3,10,15,20},
    {0.6,0.55,0.4,0.3,0.2}))