IF formula won't work!

[fidgen]

what is wrong with this? I've switched brackets around and done all sorts, but I'm banging my head now!

=IF((AVERAGE(DataRev!B2:B32))=0,#N/A,IF(Movements!$D2)=0,#N/A,(AVERAGE(DataRev!B2:B32))*Movements!$D2)

I bet its something so **** simple!


cheers
Hugh

 

[stickboy]

To fix
remove the close bracket from (movements!$d2)=0
to say ,if(movements!$d2=0,..........
hope this works for you

stuart

 

[fidgen]

thanks - is working now!

 

[Aladin Akyurek]

On 2002-09-20 03:12, fidgen wrote:
what is wrong with this? I've switched brackets around and done all sorts, but I'm banging my head now!

=IF((AVERAGE(DataRev!B2:B32))=0,#N/A,IF(Movements!$D2)=0,#N/A,(AVERAGE(DataRev!B2:B32))*Movements!$D2)

I bet its something so **** simple!


cheers
Hugh

=IF((AVERAGE(DataRev!B2:B32))=0,#N/A,IF(Movements!$D2)=0,#N/A,(AVERAGE(DataRev!B2:B32))*Movements!$D2)

Why not simply...

=AVERAGE(DataRev!B2:B32)*Movements!$D2

which would give either a non-zero or zero result?

If you rather see #N/A as result when one of the terms is 0, then

=IF(SETV(AVERAGE(DataRev!B2:B32)*Movements!$D2),GETV(),#N/A)

would be an attractive option. SETV and GETV are part of the add-in morefunc.xll, downloadable from:

http://longre.free.fr/english/index.html