Creating a Minimum Number in a Formula That Acts As a Baseline

Hi, I’m fairly new to using formulas for Monday (or excel for that matter) and I’m trying to figure out how to do a minimum number associated with a formula column. For example, my goal is to take AxB and regardless of my inputs, if it doesn’t equal at least 300, the minimum will still be 300 unless AxB exceeds that number. Any help would be much appreciated.

Thanks in advance.


Here you go:


The MAX() function returns the greatest value in the list given. So if 300 is greater than {A} * {B} then 300 is returned… otherwise {A} * {B} is returned.

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas - Part 3: Dates/Times, Strings and Status

@JCorrell Thanks a bunch. Keep this in mind for the future.