A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
=MAX(MIN(PRODUCT(H32, B35, D35), E14), 0)
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In Microsoft excel I am using the current function
=IF(Product(H32, B35, D35)<0, 0, Product (H32, B35, D35))
although I want to be able to add to the equation if the number is greater than a different cell to cap it at the different cell value?
For Example - Product(H32, B35, D35) returns 1000, Cell E14 is the max at 800, so because the amount is over 800, just return the value in that cell E14 of 800 or if it is below 800 but above 0 return the number calculated
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author