Forum Discussion

blake0995's avatar
blake0995
Copper Contributor
Jul 17, 2020
Solved

Need help for a pricing program

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?
excel
  • DevendraJain's avatar
    DevendraJain
    Jul 17, 2020

    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

     

     and then use the below mentioned formula in main sheet

     

     

DevendraJain's avatar
DevendraJain
Iron Contributor
Jul 17, 2020

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

 

 and then use the below mentioned formula in main sheet

 

 

  • blake0995's avatar
    blake0995
    Copper Contributor
    Jul 17, 2020

    sorted! DevendraJain 

     

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

    • DevendraJain's avatar
      DevendraJain
      Iron Contributor
      Jul 17, 2020

      blake0995 Thank You Very Much

       

      Please subscribe My channel

       

      https://www.youtube.com/channel/UCUNOC8izoxGb4fKvtkg2yLg?view_as=subscriber

Resources