SOLVED

Need help for a pricing program

%3CLINGO-SUB%20id%3D%22lingo-sub-1528516%22%20slang%3D%22en-US%22%3ENeed%20help%20for%20a%20pricing%20program%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528516%22%20slang%3D%22en-US%22%3E%3CP%3Ein%20this%20simple%20price%20sheet%20i've%20mocked%20up%2C%20i'm%20looking%20to%20increase%20Column%20D%20Relative%20to%20Column%20C%2C%20e.g.%20100qty%20%3D%2010%25%20discount%20etc%20etc.%20is%20there%20a%20simple%20way%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1528516%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1528774%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20for%20a%20pricing%20program%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528774%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730332%22%20target%3D%22_blank%22%3E%40blake0995%3C%2FA%3E%26nbsp%3BThere%20is%20a%20simple%20solution%20for%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20give%20discount%20depending%20on%20the%20quantity%20then%20you%20can%20give%20your%20discount%20rates%20in%20the%20selected%20cells%20below%20as%20I%20have%20given%20for%20example%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%22DevendraJain_1-1594981513465.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206018iCD10D391AA727EA8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22DevendraJain_1-1594981513465.png%22%20alt%3D%22DevendraJain_1-1594981513465.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3Band%20then%20use%20the%20below%20mentioned%20formula%20in%20main%20sheet%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%22DevendraJain_2-1594981582397.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206019i11F4E6FEE48133A9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22DevendraJain_2-1594981582397.png%22%20alt%3D%22DevendraJain_2-1594981582397.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1528791%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20for%20a%20pricing%20program%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528791%22%20slang%3D%22en-US%22%3E%3CP%3Esorted!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699938%22%20target%3D%22_blank%22%3E%40DevendraJain%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you.%20I%20just%20needed%20to%20include%20a%20couple%20of%20%24%20to%20fix%20the%20table%20array%20and%20it's%20all%20good.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1528798%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20for%20a%20pricing%20program%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528798%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730332%22%20target%3D%22_blank%22%3E%40blake0995%3C%2FA%3E%26nbsp%3BThank%20You%20Very%20Much%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20subscribe%20My%20channel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fchannel%2FUCUNOC8izoxGb4fKvtkg2yLg%3Fview_as%3Dsubscriber%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fchannel%2FUCUNOC8izoxGb4fKvtkg2yLg%3Fview_as%3Dsubscriber%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

in this simple price sheet i've mocked up, i'm looking to increase Column D Relative to Column C, e.g. 100qty = 10% discount etc etc. is there a simple way to do this?

3 Replies
Best Response confirmed by blake0995 (New Contributor)
Solution

@blake0995 There is a simple solution for this:

 

If you want to give discount depending on the quantity then you can give your discount rates in the selected cells below as I have given for example

 

DevendraJain_1-1594981513465.png

 and then use the below mentioned formula in main sheet

 

DevendraJain_2-1594981582397.png

 

sorted! @DevendraJain 

 

thank you. I just needed to include a couple of $ to fix the table array and it's all good.