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
tmfitz
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
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies