Is there a Function or set of functions on Google Sheets that reacts every multiple?-CodePudding

Okay, say I have 5 cells. Each with varying amounts. I want a function that: If(Sum(b2:b6) {greater or equal to a multiple}, True, False

So every time the total value of those cells is greater to or equal to a multiple of, say 50, so if it lands on 50n 1 or something, it'll react as if it hit 50n.

CodePudding user response：

I guess you are not multiplying but adding numbers in range, since you are using "SUM" in function. In case, here is a solution:

=IF((SUM(B2:B6))>=50;TRUE;FALSE)

Note: This code is written with Norwegian format settings. Change ";" in formula with "," for American format settings.

CodePudding user response：

sounds like:

=IF(SUM(B2:B6)>=50; 50; )