Excel function recognizes "" as 0

Asked

Viewed 111 times

1

I’m doing a very simple function in Excel, but I’m having problems, because it is recognizing "" as 0, follows the function:

=SE(E4=0;"0x0";"")

The problem is that it is returning "0x0" when I leave the cell blank, and it was to return "0x0" only when the value was 0 in the cell. What am I doing wrong?

excel

2 answers

4


Easiest way

You can do it this way

=SE(E(E4=0;E4<>"");"0x0";"")

I put an "E", so it also checks if it is different from "" (Empty string)

Using an Excel function

There is an Excel function ÉCÉL.VAZIA, which checks if the cell is empty, but I prefer the previous method, because it is smaller and easier to read.

=SE(E(E4=0;NÃO(ÉCÉL.VAZIA(E4)));"0x0";"")

More elegant answer

Ranier Cordeiro

  • 1

    Thank you very much, this solution worked perfectly.

  • Please evaluate and answer the question :)

  • I marked it as an answer, but I can’t evaluate it because I have a low reputation.

  • Thank you very much :)

1

In addition to the response of Wictor Chaves, can also be done as follows:

=SE(E4&1="01";"0x0";"")

So even if it passes through an empty cell(""), will return the value phony of condition if

  • Show, I didn’t know I could use "&" in Excel, I think it was the most elegant answer +1

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.