|
-
Jun 11th, 2004, 07:46 AM
#1
Thread Starter
Frenzied Member
Need help with Excel calculation ....
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 !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|