SOLVED

Why Am I getting a #VALUE! Display in Cell

Frequent Contributor

I'm not sure why I'm getting the "#VALUE!" displaying in a cell with the formula =IF(ISBLANK(B8),"",C8-B8).   Cell B8 is blank, so the value of the cell that is giving me the error should be blank as well but instead its throwing an error.  I'm not sure why.

3 Replies
best response confirmed by JBLT77 (Frequent Contributor)
Solution

@JBLT77 

Try

=IF(B8="","",C8-B8)

That actually worked. Not sure why the ISBLANK function didn’t work.

@JBLT77 

Perhaps B8 contains a formula that returns an empty string "".

ISBLANK returns FALSE for cells containing a formula, even if that formula returns "".