If statement returning [true value] when blank

[Blobajob88]

I've written an IF statement on excel as shown below. However I would expect the cell K132 to say "false" when the value is blank but it returns "true". Why is this? It is unique to this sheet of my workbook. When I try it on other sheets, it returns false as expected. Any help would be appreciated.

 

[Peter_SSs]

From your image we have no idea which cell is K132.
Also, your description sounds like the formula is in cell K132 yet the formula you posted refers to K132 which does not make sense.

Perhaps you could post the sample data again with XL2BB and explain in relation to the new post data.

 

[Blobajob88]

From your image we have no idea which cell is K132.
Also, your description sounds like the formula is in cell K132 yet the formula you posted refers to K132 which does not make sense.

Perhaps you could post the sample data again with XL2BB and explain in relation to the new post data.

The cell in blue is K132. The formula is in L132. When K132 is blank, it returns "TRUE" in L132, when it should return "FALSE"

 

[Peter_SSs]

The cell in blue is K132. The formula is in L132.

So when you said this..

I would expect the cell K132 to say "false"

.. did you mean "I would expect the cell L132 to say false"?


Does K132 contain a formula? If so, what is that formula?

 

[Blobajob88]

The cell in blue is K132. The formula is in L132. When K132 is blank, it returns "TRUE" in L132, when it should return "FALSE"

So when you said this..

.. did you mean "I would expect the cell L132 to say false"?


Does K132 contain a formula? If so, what is that formula?

The formula is in the top of the image if(K132="y", "TRUE", "FALSE"). So L132 should say "FALSE" when empty. K132 is where the values are inputted, the formula is in L132 only
.

 

[Peter_SSs]

The formula is in the top of the image if(K132="y", "TRUE", "FALSE").

Surely that is the formula in L132?

I asked about any formula in K132.

Most of these questions could be avoided if you posted the sample with XL2BB as suggested.

 

[Blobajob88]

Surely that is the formula in L132?

I asked about any formula in K132.

Most of these questions could be avoided if you posted the sample with XL2BB as suggested.

Yes, that is the formula in L132 like I said. The formula is in L132 only. There are no formulas in K132. It would be immediately overwritten when I input a value anyway. The only formula to concern yourself with is the if statement mentioned above.

 

[Peter_SSs]

There are no values in K132.

Then, based on your image, there is no reason why L132 would return "TRUE". If it is returning "TRUE" then there must be something happening in your worksheet/workbook that is not evident from the image. Again, that is why XL2BB could help.

 

[Peter_SSs]

What happens if you put this in cell M132?

=LEN(K132)

 

[Blobajob88]

What happens if you put this in cell M132?

=LEN(K132)

it returns #VALUE. On other sheets, this formula returns 0.