Jyggalag

New Member
Joined
Mar 8, 2021
Messages
39
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi all,

I currently have this formula:

1616744515259.png


Right now the cell is showing a blank cell.

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

1616744550590.png


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

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

1616744590870.png


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
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Zot

Well-known Member
Joined
Nov 26, 2020
Messages
1,176
Office Version
  1. 2016
Platform
  1. Windows
Are you sure you have not set not to display zero? Type 0 (zero) in empty cell and see if it become "blank"
 

Tupe77

Board Regular
Joined
Nov 26, 2020
Messages
97
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
It's did't read that well...:rolleyes:
 
Last edited:

Jyggalag

New Member
Joined
Mar 8, 2021
Messages
39
Office Version
  1. 365
  2. 2019
Platform
  1. Windows

ADVERTISEMENT

Are you sure you have not set not to display zero? Type 0 (zero) in empty cell and see if it become "blank"
It does not become blank if I type 0 in cell 2 either.

How do i fix this? :)
 

Tupe77

Board Regular
Joined
Nov 26, 2020
Messages
97
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Yes... you are right. :)
I first commented on the formula incorrectly. I read that it has a blank, but of course it had a "blank". Then I no longer had time to correct my message. Had to correct that: I didn't read it well. But there was a time out before I was done....

So there should be nothing wrong with the formula ...
 

Zot

Well-known Member
Joined
Nov 26, 2020
Messages
1,176
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

It does not become blank if I type 0 in cell 2 either.

How do i fix this? :)
Like @Tupe77 said if cell has formula then it is not considered blank

Looks like I have to read more carefully ... a bit confused
 
Last edited:

Tupe77

Board Regular
Joined
Nov 26, 2020
Messages
97
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Like @Tupe77 said if cell has formula then it is not considered blank

Looks like I have to read more carefully ... a bit confused
I confusing you. You read that just right...

Anyway:
Zero (0) is not blank even blank is zero (0).
So that logic works only one way ...
 

Jyggalag

New Member
Joined
Mar 8, 2021
Messages
39
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I confusing you. You read that just right...

Anyway:
Zero (0) is not blank even blank is zero (0).
So that logic works only one way ...

I confusing you. You read that just right...

Anyway:
Zero (0) is not blank even blank is zero (0).
So that logic works only one way ...
I tried writing =code(cell name) and this returns a value to me.

If the cell is TRULY blank, it should return #VALUE

However, how do I get the If command to understand that the cell is actually blank when nothing appears in the cell?
 

Watch MrExcel Video

Forum statistics

Threads
1,130,129
Messages
5,640,296
Members
417,135
Latest member
zeusmining

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top