Excel Formulas

[THartge]

In Excel, I have a cell (I34) that is the sum of multiple cells (H12+H16+H17+H18+H19+H20+H21+H25+H26+H28+H29+H30+H31+H32+H33). Cell I34 needs to be a minimum of $150 no matter what the sum of the multiple cells actually equals, but if cell I34 exceeds $150, it needs to show that actual sum of the multiple cells. How do I set that up. Thanks!!

[#2]

use
=MIN(150,H12+H16+H17+H18+H19+H20+H21+H25+H26+H28+H29+H30+H31+H32+H33)

[#3 · Accepted solution]

Oops
Use MAX instead of MIN

[#4]

@GeraldGreeenhough19  Thanks for the response back. It was VERY helpful and much appreciated!!