Search results

Thanks SirJB7 & others.

NARAYANK991 Using the example given above, try doing IsEmpty on A1 as well as A2. And you'll understand that IsEmpty(A1) returns true whereas IsEmpty(A2) returns false. Here is what I am looking for: If I have a cell (with formula in it) that refers to another cell (which is empty), I...

Thanks NARAYANK991 and Faseeh for writing back. Here is how it is On a new workbook, keep cell A1 blank. On cell A2, type =A1. You'll see that it shows 0 instead of blank. Using VBA, Range("A2").Value returns 0. Whereas, it isn't 0 (because A1 is blank & NOT 0). How can I make...

Formula experts, Can anyone come up with a solution to this?

Thanks Faseeh for replying. The same problem can be demonstrated using a simple cell reference For e.g. On a new workbook, keep cell A1 blank. On cell A2, type =A1. You'll see that it shows 0 instead of blank. For cell A2 to not show 0, I could write =IF(ISBLANK(A1), "", A1) However, I...

Hello there, Here is the scenario: I am writing an excel formula which is complicated, such as =OFFSET(INDIRECT(VLOOKUP(....)), 2, 0) The above will refer to a cell, of which the value could be blank. I don't know why Excel shows 0 as the value if the cell that is referred doesn't...