View Single Post
 
Old 02-11-2019, 04:43 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
I would like a method to calculate the financial return if lowest performing products (e.g. those sold at Sale price) sold at Full price.
This is different from your first post in which you were asking for a method to calculate the gain if the lowest 10 performing products are sold at the mean price. Arvi's post answered your second post while I tried a roundabout solution for post #1. I hope it gives you an idea on how you finally get the exact answers that you need.
Attached Files
File Type: xlsx Data.1.xlsx (16.7 KB, 7 views)
Reply With Quote