Aug 10 2022 07:47 AM
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.
Aug 10 2022 07:54 AM
SolutionAug 10 2022 08:27 AM
Aug 10 2022 08:38 AM
Perhaps B8 contains a formula that returns an empty string "".
ISBLANK returns FALSE for cells containing a formula, even if that formula returns "".
Aug 10 2022 07:54 AM
Solution