Forum Discussion
minimum value of one to show for a formula in excel 365
I have a estimating sheet I made that has a "check box". If the box is checked, it will take a value in a cell and minus 1 from it. The issue is, I need it to be no less than 1, so if I have a value of 1 it shows up as a 0. I have tried the min, minif, and nothing seems to work because it's not a range. My current formula is =IF(U50,(L8-1),) This works, but will show a 0 (or less) if the value in L8 becomes 1 or less.
19 Replies
In playing with it, it actual gives me a value of 1 if the box is checked or not. it does seem to work if the box is checked, but shows a value of 1 if unchecked. Sorry for the confusion.
You can update it as below to make it return nothing if the checkbox is unchecked!
=IF(U50=FALSE,"",IF(AND(U50,L8>1),(L8-1),1))
If you want it to return something else if the checkbox is unchecked, type it in between the double quotes "" in the formula.
Hope that helps
Sorry... I was correct the first time. It does not work. It still shows a 0 if the value is a one or below.
Please disregard. I had a typo this formula does work. Thank you!
