Sep 04 2022 01:21 PM
Hey guys, have a quick question about limiting the use of formulas. Right now, I have =ROUNDDOWN(xxxx,-2)-200. xxxx represents a 4-digit numbed entered. I’ve tested it, and that part works fine. (i.e. If 1461 is entered, it yields 1200).
I want to limit the formula such that values less than 1400 do not work, and values greater than or equal to 2301 don’t work. Does anyone know how I could achieve this?
Sep 04 2022 01:26 PM
It's not entirely clear to me what you want. Perhaps
=ROUNDDOWN(MAX(MIN(xxxx, 2300), 1400), -2)-200
or
=MAX(MIN(ROUNDDOWN(xxxx, -2)-200, 2300), 1400)
Sep 04 2022 01:34 PM
I guess I should be more clear. The user enters the value ‘xxxx’. I want to limit that value such that ‘xxxx’ is greater than or equal to 1400 and less than or equal to 2300.
Sep 04 2022 01:50 PM - edited Sep 04 2022 01:52 PM
Thanks. If it's about the result of the formula, use the first one I posted:
=ROUNDDOWN(MAX(MIN(xxxx, 2300), 1400), -2)-200
if you actually want to limit the value that the user can enter in cell xxxx: