How to show no negative numbers and round up to 0

Is there an EASY formula I can place around there so that if it is a negative number, it returns 0 instead of the negative? I was considering wrapping another if/then statement around is, so if formula < 0, then 0, if not then the formula but then it would end up incredibly long and confusing and I was hoping to avoid that for simplicity sake

Maybe you could MAX/MIN but I don’t think it’ll end up being shorter than your suggestion.

MAX(0;yourvalue)

MAX do a round negative to 0. Surely that’s much easier to express.

1 Like