SOLVED

Need help for a pricing program

Highlighted
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
Highlighted
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

 

Highlighted

sorted! @DevendraJain 

 

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

Highlighted