First, I know this thread is in the wrong forum, but I need the solution quickly and because the LivingRoom has the most viewers I’m posting my question here. I’ve posted this question also in The Dutch Forum, but no reply at the moment.

I’m having a problem with a formula in excel.

It’s about the next formula:

=IF(F27=0;IF($F$2=0;NA());AVERAGE(B27:F27))

De formula has to look at field F27, when there’s a 0 it should look at field F2. If that’s also a 0, then it should return NA().

If F2 has a value greater than 0 it has to give the average of field B27 -> F27.

If field F27 has a value greater than 0 it has to give immediately the average of field B27 -> F27.

At the moment I get the announcement: False when there’s a 0 in field F27.

More info: field F2 ain’t 0.

Fields B27 -> F27 are also filled with numbers.

It’s probably very simple, but I just don’t see what’s wrong.

What am I doing wrong?