Using IF(ISBLANK getting #Value! error

Hi I need help with my formula. I entered =IF(ISBLANK(B4),"",B4-100) in cell C4 and it worked out just fine. Now I am trying to reference cell C4 using =IF(ISBLANK(C4),"",E3-C4) in cellE4 and I am ge...

excel

Formulas and Functions

Riny_van_Eekelen
May 13, 2021
brendababy02 Try this:
=IF(C4="","",E3-C4)
With =ISBLANK(B4) an empty cell returns TRUE in C4, otherwise FALSE. In your case the formula results in "", which is not empty, when B4 contains nothing (i.e. is blank). Thus, the formula always executes the FALSE argument, E3 - "" (a number minus a text). Hence, #VALUE!

Forum Discussion

Using IF(ISBLANK getting #Value! error

Resources