Forum Discussion
Solved
Help with creating a formula with imbedded calculations
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 multip...
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.
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.
Good solution! It took me a while to understand the logic of the formula, is really cool.