1. I can't get this formula to work

=IFERROR("",P37/COUNTIF(\$D\$37:\$O\$37,">0"))

E37 contains 50 F37 contains 100 result should be 75 I get blank cell

Regards

2. are the parameters to IFERROR supposed to go that way round - shouldn't it be calculation first, followed by "" to replace possible errors?

3. [quote name='jeremybarker' post='788135' date='09-Aug-2009 09:54']are the parameters to IFERROR supposed to go that way round - shouldn't it be calculation first, followed by "" to replace possible errors?[/quote]

Hi

This works OK =IFERROR("",C42/C41)

Regards

4. The syntax for IFERROR is

=IFERROR(expression, value_if_error)

It will return the value of expression unless expression returns an error, then it will return value_if_error.

You use "" as expression; this will obviously never return an error, so the formula will always return "", and P37/COUNTIF(\$D\$37:\$O\$37,">0") will be ignored completely.

Try

=IFERROR(P37/COUNTIF(\$D\$37:\$O\$37,">0"),"")

as suggested by Jeremy.

5. [quote name='HansV' post='788141' date='09-Aug-2009 10:46']The syntax for IFERROR is

=IFERROR(expression, value_if_error)

It will return the value of expression unless expression returns an error, then it will return value_if_error.

You use "" as expression; this will obviously never return an error, so the formula will always return "", and P37/COUNTIF(\$D\$37:\$O\$37,">0") will be ignored completely.

Try

=IFERROR(P37/COUNTIF(\$D\$37:\$O\$37,">0"),"")

as suggested by Jeremy.[/quote]
Thank you Hans for the precise explanation and apologies to Jeremy

Regards