SpeedyFingers
New Member
- Joined
- Mar 26, 2012
- Messages
- 38
I don't understand what I am doing wrong when I know how simple this is. The "NPV" will show for the File Type 1 but I am getting a "FALSE" with the File Type 2 and not cell AG3 that i'm referencing. Please help!
S3 = File Type
AC = Amount
AP = A specific amount
AG = Location Type
S3 = File Type
AC = Amount
AP = A specific amount
AG = Location Type
Code:
=IF(A3="","",IF($AC3>$AP$1,"NPV",IF(AND($S3="File Type 1",$AC3>$AP$1)="NPV",$AG3,IF($AC3>$AP$1,"NPV",IF(AND($S3="File Type 2",$AC3>$AP$1)=AG3,"NPV")))))