Forum Discussion
Solved
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...
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!
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!
It worked, thank you. I need to learn more about Excel.