ISNULL () or ISEMPTY() ISZERO()

Question

Hi Microsoft,   In Excel, if cell contains 0 value and another cell contains blank, if we compare two these showing TRUE, in actuality this is not the case.   And another thing is that, if the formula returns double quote “”, then it evaluates differently for comparison purposes.  

I am of the view that there must be the formulas to check this in simple way.   ISNULL () or ISEMPTY() ISZERO()

Regards,

Excel Lover

Answer 1

I understand, often in Excel seemingly simple tasks can be quite complicated, hopefully your feedback will be taken on board.

Kind Regards,

Elise

Answer 2

Since this is a special functionality, IMHO it will probably not be implemented.

The best way to increase the chance of implementation is to make a suggestion here:
Welcome to Excel’s Suggestion Box!

If your proposal receives enough votes, it will be examined by Microsoft, accepted or rejected.

From my point of view the chance for this is low, because the existing advanced solutions such as Power Query, Power Pivot, etc. can analyze data without such issues.

In the interim you can write your own VBA function and call it as UDF from your formula to determine if a cell has a special contents. Here is the article how to do that:

Create custom functions in Excel

Andreas.

Yes, I have emailed to MS in feedback and suggestion, and also send an email.

PQ can do such stuff, I agree but formula has its own value and usefulness, and these are important data analysis formulas, and must be available within the Excel formula kit.

Answer 3

Since this is a special functionality, IMHO it will probably not be implemented.

The best way to increase the chance of implementation is to make a suggestion here:
Welcome to Excel’s Suggestion Box!

If your proposal receives enough votes, it will be examined by Microsoft, accepted or rejected.

From my point of view the chance for this is low, because the existing advanced solutions such as Power Query, Power Pivot, etc. can analyze data without such issues.

In the interim you can write your own VBA function and call it as UDF from your formula to determine if a cell has a special contents. Here is the article how to do that:

Create custom functions in Excel

Andreas.

Answer 4

Hi, I'm Elise, and I'd be happy to help with your issue.

Unfortunately there isn’t a formula which combines all of these, your best solution would be to create a formula which combines all of these using the OR function, please see here for more details on how to use this:

https://support.microsoft.com/en-us/office/or-f...

Please let me know if you need any further assistance.

Kind Regards,
Elise

Thanks Elise for your response. I know these but to do a simple task, you have to write a bit cumbersome formula. I have emailed Microsoft and requested them to provide these functionality (as narrated above), as these functionalities are very common in any database analysis requirement.

Regards,

Answer 5

Hi, I'm Elise, and I'd be happy to help with your issue.

Unfortunately there isn’t a formula which combines all of these, your best solution would be to create a formula which combines all of these using the OR function, please see here for more details on how to use this:

https://support.microsoft.com/en-us/office/or-f...

Please let me know if you need any further assistance.

Kind Regards,

Elise