Jacob, Gary, David and Rick:

I should have clarified that the formulae I'm showing in A2 and A3 are very
simple ones. In the spreadsheet that I'm working on, they are fairly
complex. All of you are right in that if they were as simple as the ones
shown, the approaches that you suggested would work.

I ended up using something along the lines of =IF(a3=" ",...,...), but
wanted to know if there was some way of inserting a blank, but it does not
seem feasible.

Thanks for all your suggestions.

"Rick Rothstein" wrote:

Why not just test the cell's value?

=IF(A1="","A1 is blank","A1 has something in it")

--
Rick (MVP - Excel)


"bearspa" wrote in message
...
I'm having a problem inserting a blank in a cell using a function so that
another formula that refers to this blank reads it as a blank.

For example, if A1 is a blank cell:

Formula Result

=ISBLANK(A1) TRUE
=IF(ISBLANK(A1)," ",1)
=ISBLANK(A3) FALSE

In the above example, even though =IF(ISBLANK(A1)," ",1) shows a blank
cell
in A3, a reference to it in another formula shows that Excel does not
think
it is blank.

How do you write a formula so that there is truly nothing in the cell as a
result?