I am trying to create a formula where when each of three consitions is met
with a specific response/text string.
Spreadsheet sample
Col. G Col. J Col. N
Col. O
Target Target Target
II-A
Good Standing Good Standing Good Standing
Good Standing
Good Standing Target Target
Target
Target Good Standing Target
II-A

Situation: If a system receives a "Target" indicator in column G and a
"Target" indicator in either one or both cols. J and N, they should receive a
new indicator "II-A" in column O. If a system receives "Good Standing" in
columns G, J, and N, they receive "Good Standing" as their final indicator in
col O. If they receive a "Good Standing" in Col G, but a "Target" indicator
in either or both cols. J and N, they should recieve a "Target" indicator in
Col. O. I used the following formula, but it isn't working:
=IF((AND(LEFT(G4,3)="tar",LEFT(N4,3)="tar"), "II-A
Improvement"),IF(AND(LEFT(G4,3)="tar",LEFT(J4,3)=" tar"),"II-A
Improvement"),IF(AND(LEFT(G4,3)="goo",LEFT(J4,3)=" goo",LEFT(N4,3)="goo","Good
Standing","Target"))). Please help! Thanks!