Ask Your Question

Set a minimum amount for formula

asked 2020-08-19 16:04:45 +0100

So, I have this small calc sheet. I have some set of values that decrease when I input my numbers on the right. One of these cells, likely inelegantly, takes values from two different cells, but one of them should never go below "0" when subtracting. I want that cell to know that even if it goes subzero, it should always display and have as its value no less than "0".

Thanks for the help!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-08-19 16:39:42 +0100

erAck gravatar image

Use MAX(A1;0) in the calculation for that cell if it is A1, for example.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-08-19 16:04:45 +0100

Seen: 24 times

Last updated: Aug 19 '20