Share via

Microsoft Excel formula help

Anonymous
2024-10-02T15:16:35+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments No comments

Answer accepted by question author

HansV 462.6K Reputation points
2024-10-02T15:44:50+00:00

=MAX(MIN(PRODUCT(H32, B35, D35), E14), 0)

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful