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... ????
The common cause for this issue is the calculation option being set to Manual, please make sure the calculation option is set to Automatic as shown in Sergei's reply.
Regards
It is set on Automatic. It's very odd. If I just take a random cell and type 1, another 4, and another "=" the two cells x each other, it coms up with 4. But if I use the values from those cells (one cell = the cell that has the "1", and one cell = the one that has the 4, it equals 2???
