Forum Discussion
minimum value of one to show for a formula in excel 365
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
OK.. this WORKED!!!! Good news! However, have you seen this before? See picture. 1 X 4 = 4. Not 2. This is pulling the information form the cells with your formula in them. Does not matter if another cell equal that value, restart the computer... ????
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!
Won't work. Just giving me "there's a problem with this formula" message, but not saying what the issue is.
