Jyggalag

Active Member
Joined
Mar 8, 2021
Messages
422
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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Your index formula last part is cell reference? Are you sure it right way to do that?
 
Upvote 0
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.
 
Upvote 0
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? :) )
 
Upvote 0
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 ?
 
Upvote 0
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?
 
Upvote 0
Time for me to go home now ... sorry cannot find out what is the problem now ..
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

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
Back
Top