IfError combined with Countblank

[julhs]

Just want to be sure that the below is the correct way to structure the formula, or is there a better way?
In N21 I have this that is working:

=IFERROR(IF(COUNTBLANK(N16:N19)="","",(((((N16*1000)/N17)/(N19/N17))*N18)/N20)*M20),"Entries above are incomplete")

Without using

“IFERROR”

and

“IF(COUNTBLANK(N16:N19)="","",”

then the calculation

(N16*1000)/N17)/(N19/N17))*N18)/N20)*M20

results in a

#Value error”

if any cell in N16:N19 is blank.

Is there a better formula?

 

[Scott Huish]

That can't be working because COUNTBLANK always returns a number, even if it is 0. It would never return an empty string.

But I suspect, this would do what you want:
=IF(COUNT(N16:N19)=4,(((((N16*1000)/N17)/(N19/N17))*N18)/N20)*M20,"Entries above are incomplete")

 

[julhs]

Hi Scout, thank you for response.
But;

=IFERROR(IF(COUNTBLANK(N16:N19)="","",(((((N16*1000)/N17)/(N19/N17))*N18)/N20)*M20),"Entries above are incomplete")

IS working if any cell in N16:N19 is “Blank”, aka ””, (eg: no formula, no nothing)
With my formula; N21 is returning "Entries above are incomplete" if any cell in N16:N19 is “Blank”.
This is about, is there a better way to write the formula, than the formula itself not work?

 

[Scott Huish]

It's not working because of the COUNTBLANK, it's working because of the ISERROR (probably #DIV/0!). Your COUNTBLANK will never return TRUE.

Did you try my formula?

 

[julhs]

Hi Scott
Based on what you said in post #2 about CountBlank I played around with changes to my formula.
You of coarse where right in that the way I’d used the Countblank couldn’t work (didn’t understand how it worked, never used it before), but it transpires that the way I had used it it DIDN’T actually do anything other than give me the correct number of arguments in the formula for it to compute.

And again your right on this; what infact made it appear that the Countblank part was working had nothing to do with Countblank it was actually the IFERROR part.
This is my rejigged formula that works in N21 just using IFERROR to prevent a #DIV error if any of N16:N19 are blank;

= IFERROR(((((N16*1000)/N17)/(N19/N17))*N18)/N20*M20,"Entries above are incomplete ")

And then I have your COUNTBLANK way;

=IF(COUNT(N16:N19)=4,(((((N16*1000)/N17)/(N19/N17))*N18)/N20)*M20,"Entries above are incomplete ")

Will use yours as it eliminates the #DIV error in the first place, rather than handle the error with IFERROR
Many thanks for your help.
Julhs