Hi
please take a minute to post a sample sheet ( no pics please) explaining your problem when starting a thread, adding some data and desired results.



The fact there is a formula in a cell does not affect the result of ISBLANK.
BUT when the result of a formula is "" ( the empty text string), ISBLANK returns FALSE, although it looks blank...
To check if a cell is blank, using COUNTBLANK is better. If the cell contains "", COUNTBLANK returns 1.

So instead of = ISBLANK(A1), say, instead use =IF(COUNTBLANK(A1)=0...

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post