Need help with Excel calculation ....

[TheBionicOrange]

I need the syntax for the following calculation.

I can never get this right as there always seems to be loads of brackets involved.

Any of you bright sparks out there fancy taking this one on ?

IF J4=P4 AND K4=Q4 THEN
Range("A1").Value = Range("A1").Value + 1
ELSE
IF (J4 > K4 AND P4 > Q4) OR (J4=K4 AND P4=Q4) OR (J4<K4 AND P4<Q4) THEN
Range("A1").Value = Range("A1").Value + 1
ENDIF
ENDIF

Hope thats readable !

[TheBionicOrange]

OK almost done.

All I need now is the correct Excel syntax for the following :

IF (DJ38=H37 OR DJ38=I37) AND DJ38 <> F41 THEN
5
ELSE
0
ENDIF

Any takers ?

[Ecniv]

Originally posted by TheBionicOrange
IF J4=P4 AND K4=Q4 THEN
Range("A1").Value = Range("A1").Value + 1
ELSE
IF (J4 > K4 AND P4 > Q4) OR (J4=K4 AND P4=Q4) OR (J4<K4 AND P4<Q4) THEN
Range("A1").Value = Range("A1").Value + 1
ENDIF
ENDIF

Hope thats readable !

That makes no sense - where is the formula going??

This is the formula in a4

=IF(OR(AND(J4=P4,K4=Q4),OR(AND(J4>K4,P4>Q4),AND(J4=K4,P4=Q4),AND(J4<K4,P4<Q4))),1,0)

That puts a 1 or 0 depending.. which you can either count or sum.


Vince

[si_the_geek]

do you mean you want this in a cell formula?

if so...

IF (  AND(   OR (DJ38=H37, 
                         DJ38=I37), 
               DJ38 <> F41) 
     , 5
     , 0)

[Ecniv]

Originally posted by TheBionicOrange
OK almost done.

All I need now is the correct Excel syntax for the following :

IF (DJ38=H37 OR DJ38=I37) AND DJ38 <> F41 THEN
5
ELSE
0
ENDIF

Any takers ?

=if(and(or(dj38=h37,dj38=i37),dj38<>f41),5,0)

[TheBionicOrange]

OK thanks for the help guys.

I'm at home now and won't be back in till Monday, so I'll try then.

Thanks again.

[TheBionicOrange]

Thanks Ecniv ... that worked just fine