Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




Cost of each whole unit beyond
Hi,
I am trying to do the logic on the far right en masse for a set of data, but need to find a way to always formulaically pick the whole unit(s) cost above a threshold of 103%. See Examples below example 1  85 Units Received is 103.7% of 82 Units Ordered so, not the .7% x 14.79, but rather unit 85 pushed overage over 103% so 1 Unit x 14.79 example 2  1,085 Units Received is 108.3% of 1,002 Units Ordered so not the 5.3% x 14.79, but rather unit 1,034 pushed us over so (1,0851,033)x14.79 Essentially the cost of every unit that violated our policy of 103% threshold. Thanks! 
#2
Posted to microsoft.public.excel.misc




Cost of each whole unit beyond
On Thursday, September 15, 2016 at 3:05:16 PM UTC4, GoTeamGo4321 wrote:
Hi, I am trying to do the logic below en masse for a set of data, but need to find a way to always formulaically pick the whole unit(s) cost above a threshold of 103%. See Examples below example 1  85 Units Received is 103.7% of 82 Units Ordered so, not the .7% x 14.79, but rather unit 85 pushed overage over 103% so 1 Unit x 14.79 example 2  1,085 Units Received is 108.3% of 1,002 Units Ordered so not the 5.3% x 14.79, but rather unit 1,034 pushed us over so (1,0851,033)x14.79 Essentially the cost of every unit that violated our policy of 103% threshold. Thanks! 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Creating a total cost chart where a component cost is a step cost  Charts and Charting in Excel  
How to calculate unit cost  Excel Programming  
Current Cost versus Original Cost  New Users to Excel  
Confusion on adding percentage of cost to that cost.  Excel Worksheet Functions 