Cell is blank, but has a formula in it.

[wkirkcrawford]

Greetings,

I'm using a Surface RT, therefore, I can't use VBA.

I'm trying to put a 'Date' and 'Time' Stamp into two cells when data is added.

But I check the time cell and do a difference between the time before.

The cell for date, =IF(K8<>"",IF(H8="",NOW(),H8),"") DATESTAMP
The cell for time, =IF(K8<>"",IF(I8="",NOW(),I8),"") TIMESTAMP
The cell that check the difference between times, =IF(ISBLANK(I8),"",MOD(I8-AA7,1))

The cell that check time show "VALUE", which implies that the cell is NOT BLANK.

I could added another IF because two cell will be filled out by data that I put in.

It worked until I added that 'TimeDateStamp'.

Is there another way to check if a cell is not showing data?

W. Kirk Crawford
Tularosa, New Mexico

 

[barry houdini]

Try using

=IF(I8="",.......

That will return TRUE if I8 is actually blank or if it contains "" generated by a formula

 

[wkirkcrawford]

Barry,

Thank you for the very quick response.

That worked. I guess, ISBLANK is for really blank cells.

Thanks again for your help.

W. Kirk Crawford
Tularosa, New Mexico