Jan 05 2022 04:22 PM
I am trying to create a formula which will calculate a result
for =sum{1-10 items purchased will multiply by 3.35}+{additional items 11-19 will multiply by .70}+{additional items over 20 will multiply by .30}
example:4items is $13.40 13items is $35.60 23items is $41.00
is this possible?
Jan 05 2022 10:00 PM - edited Jan 05 2022 10:48 PM
Solution@CLC65 The attached file contains an example of one way to do it. Perhaps not the most straight-forward way, but certainly a very effective one.
By the way, I believe your calculation for 23 items is off by 40 cents.
Jan 05 2022 10:42 PM
Jan 08 2022 03:14 PM
thank you, this will be one way of solving the calculations @Riny_van_Eekelen