Forum Discussion
blake0995
Jul 17, 2020Copper Contributor
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?
- 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
Jul 17, 2020Iron Contributor
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