Home

Excel formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-621845%22%20slang%3D%22en-US%22%3EExcel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-621845%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20multiply%20a%20cell%20by%20a%20different%20number%20depending%20on%20the%20size%20of%20the%20number%20in%20the%20cell%2C%20how%20do%20I%20write%20the%20formula%20for%20this%3F%3C%2FP%3E%3CP%3EIf%20the%20cell%20number%20is%20less%20than%20or%20equal%20to%2020%2C%20if%20the%20cell%20is%20less%20than%2055%20but%20more%20than%2020%2C%20if%20the%20cell%20is%20greater%20than%20or%20equal%20to%2055.%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20out%3F%20I%20thought%20the%20%22IF%22%20statement%20would%20work%20but%20I%20can't%20get%20it%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-621845%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-622223%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-622223%22%20slang%3D%22en-US%22%3EIf%20the%20multipliers%20are%201%2C%202%2C%20and%203%2C%20respectively%2C%20use%20LOOKUP%20instead%20of%20IF%20like%20this%3A%3CBR%20%2F%3E%3DLOOKUP(A2%2C%3CBR%20%2F%3E%7B1%2C21%2C55%7D%2C%3CBR%20%2F%3E%7B1%2C2%2C3%7D)*A2%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted
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
Related Conversations
Sourcing array from cell
mryno in Excel on
1 Replies
SUMMING
dumby58 in Excel on
1 Replies
how to set 2E02 into escel
Daryl20 in Excel on
5 Replies
Trouble with formulas MIN/MAX within IF statements
BDB1973 in Excel on
6 Replies
Openen en opslaan WORD en EXCEL
Turke100 in Excel on
0 Replies
historical stock data
onassis78 in Excel on
0 Replies