CODEWITHSUNDEEP
if-statementgoogle-sheetsgoogle-sheets-formula
Reventon
Reventon

Reputation: 13

How to limit a max value in a cell?

I am setting up a new spreadsheet in google spreadsheets and I need to set a max value because it can surpass that number.

I am currently using this formula -> =SUMPRODUCT(D17:D33) and that sum can be more than 50, and if that's true, I want to limit to 50.

Any tips?

Upvotes: 1

Views: 4034

Answers (2)

pnuts
pnuts

Reputation: 59475

Please try:

=min(50;sumproduct(D17:D33))

Upvotes: 1

player0
player0

Reputation: 1

try something simple like:

=IF(SUMPRODUCT(D17:D33)>50; 50; SUMPRODUCT(D17:D33))

0

Upvotes: 0

Related Questions