Forum Discussion
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 $...
- 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}))
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}))
=E1*(1+LOOKUP(E1,
{0,3,10,15,20},
{0.6,0.55,0.4,0.3,0.2}))