Jul 17 2020 01:17 AM
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 03:26 AM
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
and then use the below mentioned formula in main sheet
Jul 17 2020 03:34 AM
sorted! @DevendraJain
thank you. I just needed to include a couple of $ to fix the table array and it's all good.
Jul 17 2020 03:37 AM
@blake0995 Thank You Very Much
Please subscribe My channel
https://www.youtube.com/channel/UCUNOC8izoxGb4fKvtkg2yLg?view_as=subscriber
Jul 17 2020 03:26 AM
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
and then use the below mentioned formula in main sheet