Excel not showing blank in formula when I want it to

[Jyggalag]

Hi all,

I currently have this formula:

Right now the cell is showing a blank cell.

I then have another cell that links to this cell through this formula:

This cell also shows blank, because the first cell is blank.

I then have a third and final cell with this formula:

However, this cell returns the value "Not blank", which it should not, because the other two cells are both blank (specifically the second one, which this one links to).

Can somebody please help me out on how to fix this?

Thank you so much!

Best regards,
Jyggalag

 

[Jyggalag]

What value?

48 in my case

 

[Zot]

48 in my case

Didn't 48 means 0?

 

[Tupe77]

Your index formula last part is cell reference? Are you sure it right way to do that?

 

[Tupe77]

Today is a bad morning, I shouldn’t write anythink. I mean, are you sure of the value returned by that cell reference? Otherwise areas defined must be wrong because I think the formula itself is just right.

 

[MARK858]

Didn't 48 means 0?

Yes it does

 

[Jyggalag]

Yes it does

But CODE(cell name) returns the value 48 for me. This might mean 0, but I read online that unless CODE(cell name) returns #VALUE, an if or iferror function wont return the cell as blank when you set up your conditions (but rather return it as not blank), which is why my initial question in this thread is unsolveable (unless somebody has a solution? )

 

[Zot]

But CODE(cell name) returns the value 48 for me. This might mean 0, but I read online that unless CODE(cell name) returns #VALUE, an if or iferror function wont return the cell as blank when you set up your conditions (but rather return it as not blank), which is why my initial question in this thread is unsolveable (unless somebody has a solution? )

What puzzled me is that you said when you type 0 in a cell, it did not disappear, meaning that the sheet is displaying 0. My default is suppressed zero value ?

 

[Jyggalag]

What puzzled me is that you said when you type 0 in a cell, it did not disappear, meaning that the sheet is displaying 0. My default is suppressed zero value ?

Weird Do you know how I can fix it?

 

[Zot]

Time for me to go home now ... sorry cannot find out what is the problem now ..

 

[Jyggalag]

Time for me to go home now ... sorry cannot find out what is the problem now ..

No worries Zot, I appreciate it anyway!

If anybody else has a solution, please let me know :D