SOLVED

Why Am I getting a #VALUE! Display in Cell

Iron 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 JBLT-77 (Iron Contributor)
Solution

@JBLT-77 

Try

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

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

@JBLT-77 

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

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

1 best response

Accepted Solutions
best response confirmed by JBLT-77 (Iron Contributor)
Solution

@JBLT-77 

Try

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

View solution in original post