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 less than 55 but more than 20, if the cell is greater than or equal to 55.
Can someone help me out? I thought the "IF" statement would work but I can't get it to work.
1 Reply
- 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
