Forum Discussion
dangercoy
Mar 19, 2020Copper Contributor
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
- TwifooSilver ContributorYour formula in F1 could be:
=E1*(1+LOOKUP(E1,
{0,3,10,15,20},
{0.6,0.55,0.4,0.3,0.2}))