IF THEN constructs

%3CLINGO-SUB%20id%3D%22lingo-sub-2629977%22%20slang%3D%22en-US%22%3EIF%20THEN%20constructs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2629977%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20calculate%20product%20cost%20and%20extension%20based%20on%20the%20quantity%20entered%20into%20a%20cell.%26nbsp%3B%20I%20have%203%20different%20prices%20based%20on%20the%20quantity%20entered%20into%20a%20cell.%26nbsp%3B%20A%20unit%20cost%20for%20quantities%20of%201-10%2C%20a%20different%20unit%20cost%20for%20quantities%20of%2011-100%2C%20and%20a%20third%20option%20for%20quantities%20of%20101-200.%26nbsp%3B%20The%20unit%20cost%20will%20automatically%20be%20applied%20based%20on%20the%20quantity%20entered%20into%20the%20quantity%20column.%26nbsp%3B%20Sound%20easy%20enough%20but%20I%20can%20seem%20to%20get%20it%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2629977%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2630026%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20THEN%20constructs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2630026%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%26gt%3B%20%3DI%20am%20able%20to%20get%20paid%2088%20dollars%20per%2Fhr%20for%20working%20part-time%20on%20apple%20laptop.%20I've%20not%20at%20all%20thought%20like%20it%20is%20even%20possible%20however%20my%20closest%20buddy%20receiving%20%2427k%20just%20within%20three%20weeks%20simply%20completing%20this%20simple%20job%20%26amp%3B%20she%20influenced%20me%20to%20try...Get%20better%20instructions%20through%20following%20article.%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%26gt%3B%20**GO%20HERE**%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%26gt%3B%20%23%23%23%20%3CA%20href%3D%22https%3A%2F%2Fbit.ly%2F37zbNP7%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fbit.ly%2F37zbNP7%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2630362%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20THEN%20constructs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2630362%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1124453%22%20target%3D%22_blank%22%3E%40Gene_LaValle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23FF0000%22%3EFirst%20of%20all%2C%20please%20ignore%20the%20previous%20post.%20I%20suspect%20that%20it%20is%20a%20scam%20and%20have%20reported%20it%20to%20the%20moderator.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20regard%20to%20your%20question%2C%20I%20would%20be%20easiest%20to%20create%20a%20lookup%20table%20where%20you%20specify%20the%20lower%20boundaries%20for%20the%20pricing%20categories.%20Then%20use%20LOOKUP%20to%20match%20the%20quantity%20to%20the%20correct%20unit%20price.%20I%20have%20used%20named%20ranges%20(%22lower%22%20and%20%22up%22)%20to%20make%20the%20formula%20easier%20to%20read.%20See%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-10%20at%2007.10.00.png%22%20style%3D%22width%3A%20341px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301949i93173145185B51AD%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-10%20at%2007.10.00.png%22%20alt%3D%22Screenshot%202021-08-10%20at%2007.10.00.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I want to calculate product cost and extension based on the quantity entered into a cell.  I have 3 different prices based on the quantity entered into a cell.  A unit cost for quantities of 1-10, a different unit cost for quantities of 11-100, and a third option for quantities of 101-200.  The unit cost will automatically be applied based on the quantity entered into the quantity column.  Sound easy enough but I can seem to get it working.

1 Reply

@Gene_LaValle 

First of all, please ignore the previous post. I suspect that it is a scam and have reported it to the moderator.

 

With regard to your question, I would be easiest to create a lookup table where you specify the lower boundaries for the pricing categories. Then use LOOKUP to match the quantity to the correct unit price. I have used named ranges ("lower" and "up") to make the formula easier to read. See attached.

 

Screenshot 2021-08-10 at 07.10.00.png