Forum Discussion
Using IF(ISBLANK getting #Value! error
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!
Riny_van_Eekelen Worksheet is attached. It's kind of a messy work in progress.
Basically, I'm building a estimating worksheet for services offered. Some services are offered on a per word (it's a copyediting business) basis, and some are offered for a flat fee. On my form tab, I need the per price and word count to fill in if the service is per word and the total cost to auto-calculate. But if there's a flat fee, I want Per Price and Word Count to remain blank, and I want the flat fee to appear instead of a per-price total. Hope that makes sense.
I started out trying to use ISBLANK formulas (which seems to work in my Per Price column, but maybe that's just an illusion).
Thanks for taking a look!
juliejo Tried to open your file. Noticed you have ActiveX controls. On a Mac right now, so that doesn't work for me. Perhaps someone else. Sorry!