Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Help with creating a formula with imbedded calculations

Copper Contributor

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?

 

 

3 Replies
best response confirmed by Hans Vogelaar (MVP)
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.

Good solution! It took me a while to understand the logic of the formula, is really cool.

thank you, this will be one way of solving the calculations @Riny_van_Eekelen 

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
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.

View solution in original post