Forum Discussion
Excel formula help
I want to multiply a cell by a different number depending on the size of the number in the cell, how do I write the formula for this? If the cell number is less than or equal to 20, if the cell is l...
If the multipliers are 1, 2, and 3, respectively, use LOOKUP instead of IF like this:
=LOOKUP(A2,
{1,21,55},
{1,2,3})*A2
=LOOKUP(A2,
{1,21,55},
{1,2,3})*A2