Tupelo1984
New Member
- Joined
- Jan 26, 2021
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Hi all,
I am in desperate need of help on an item!
I am looking for a formula that returns a result based on the % of sales volume for a specific product (column B) over to the total value of the order (grouped column A) is equal or more than 60% . The result to be displayed in column D with "60% X order" or "Less than 60% X order" depending on the % of X products over the total order from column A.
Example:
Order B in spreadsheet
As the SUM of the item value for X products is lower than 60% of the total value of the items for order A, it would return result "Less than 60% X order" in column D
Order C in spreadsheet
As the SUM of the item value for X products is higher than 60% of the total value of the items for order A, it would return result "60% X order" in column D.
Thank you so much for your help in advance!
Tupelo1984
I am in desperate need of help on an item!
I am looking for a formula that returns a result based on the % of sales volume for a specific product (column B) over to the total value of the order (grouped column A) is equal or more than 60% . The result to be displayed in column D with "60% X order" or "Less than 60% X order" depending on the % of X products over the total order from column A.
Example:
Order B in spreadsheet
Order B manual calculation | |
130593.19 | Total Sum all products A |
43874.02 | Total Sum X products A |
34% | % of X products in Order A |
As the SUM of the item value for X products is lower than 60% of the total value of the items for order A, it would return result "Less than 60% X order" in column D
Order C in spreadsheet
Order C Manual calculation | |
60200 | Total Sum all products in order C |
60000 | Total Sum X products in order C |
99.67% | % of X products in Order C |
As the SUM of the item value for X products is higher than 60% of the total value of the items for order A, it would return result "60% X order" in column D.
Thank you so much for your help in advance!
Tupelo1984