Testing for Empty Cells

**ptmuldoon** · 09-30-2014, 09:00 PM

This has likely been asked before, and I'm trying to learn and get this right, but struggling with. In my various spreadsheets I have if statements that often show a "Blank" with something like this"

=IF(F7=0,"","Not Blank")

Now I'm trying to create a customfunction that will search a range, and then tell me either Yes or No if all of the cells are truly blank, no formula's, etc.

I think this is close, yet it keeps returning a 0 for an answer?

Please Login or Register  to view this content.

**humdingaling** · 10-01-2014, 12:19 AM

Please Login or Register  to view this content.

didnt use isempty to avoid confusion with vba formula

**ptmuldoon** · 10-01-2014, 08:44 AM

Thanks,

I think the key piece I was missing and forgot is that when creating a custom function, you need to return the custom function name as the result. Is that correct?

**humdingaling** · 10-01-2014, 08:35 PM

that is generally the case...i dont really have much experience in custom functions to be honest

my code works on premise
if any cells is not empty...its automatic no and exit
if code goes all the way thru the for loop meaning every cell passes empty check...then empty is yes
not quite sure what your if is doing

also don't declare double when you want a string output
you get a #value error