Hi all, l got a below sheet template for my business. l would like to calculate the total price to my customer based on the information below & there are some challenge on it when l decide to use "query & if error" function for returning the result.
https://docs.google.com/<wbr>spreadsheets/d/<wbr>11rJvq06GgFV5hA_<wbr>OIh419zHGYMtY0V9JQeFPpqSBE-A/<wbr>edit?usp=sharing
Below are the summary of what l want to get:
1. 3 tiers for price calculation - must be meet the same day target of each customer
2. only 1 size M/L CANNOT count as bulk order, even Size M = 2 Size S or Size L = 3 Size S.
3. The price will be count for the nearest tier and the orders will be deducted of that tier range until the orders can be totally calculated.
Moreover, l opened a "Different case" sheet, it shows diff. scenario for the calculation.
I hope someone can help me on it and really appreciate the hard work of you guys!!
I have already working for this over one month but still cannot work it out.
Thank you
https://docs.google.com/<wbr>spreadsheets/d/<wbr>11rJvq06GgFV5hA_<wbr>OIh419zHGYMtY0V9JQeFPpqSBE-A/<wbr>edit?usp=sharing
Below are the summary of what l want to get:
1. 3 tiers for price calculation - must be meet the same day target of each customer
2. only 1 size M/L CANNOT count as bulk order, even Size M = 2 Size S or Size L = 3 Size S.
3. The price will be count for the nearest tier and the orders will be deducted of that tier range until the orders can be totally calculated.
Moreover, l opened a "Different case" sheet, it shows diff. scenario for the calculation.
I hope someone can help me on it and really appreciate the hard work of you guys!!
I have already working for this over one month but still cannot work it out.
Thank you
