Thanks for the feedback - glad to help.

Pete

On Feb 8, 4:49 pm, "alex" wrote:
On Feb 8, 11:37 am, "Pete_UK" wrote:





Try this:

=IF(A1="","blank but not empty","contains something else")

Hope this helps.

Pete

On Feb 8, 4:33 pm, "alex" wrote:

Hello experts,

I'm trying to use the isBlank() function to in one cell to reference
another directly to the right.

Problem is, however, that said cell to the right, while holding a null
value, also has a formula causing the isBlank function to return
false.

Is there a function that will return true if the cell is empty and has
an associated formula?

Thanks for the time,
alex- Hide quoted text -

- Show quoted text -

Pete,

You helped answer my question: instead of using isBlank, I used "".

Thanks.- Hide quoted text -

- Show quoted text -