Remember Me? December 9th 05, 09:47 PM posted to microsoft.public.excel.worksheet.functions
 Brenda S. Posts: n/a Nested function

I am trying to create a formula where when each of three consitions is met
with a specific response/text string.
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 December 10th 05, 04:37 AM posted to microsoft.public.excel.worksheet.functions
 Biff Posts: n/a Nested function

Hi!

Try this:

=IF(AND(G4="target",OR(J4="target",N4="target"))," II-A",IF(AND(G4="good
standing",J4="good standing",N4="good standing"),"good
standing",IF(AND(G4="good
standing",OR(J4="target",N4="target")),"target","" )))

Biff

"Brenda S." wrote in message
...
I am trying to create a formula where when each of three consitions is met
with a specific response/text string.
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
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 December 12th 05, 08:36 PM posted to microsoft.public.excel.worksheet.functions
 Brenda S. Posts: n/a Nested function

Thank you so much! I did have to include one other "scenario" to get the
formula to work. I'm enclosing the corrected formula below. The One you
sent did two "groups" correctly, but displayed nothing for the "Target"

=IF(AND(G4="target",OR(J4="target",N4="target"))," II-A
Improvement",IF(AND(G4="good standing",J4="good standing",N4="good
standing"),"Good Standing",IF(AND(G4="good
standing",OR(J4="target",N4="target")),"Target",IF (AND(G4="Target",OR(J4="Good Standing",N4="Good Standing")),"Target","Target"))))

"Biff" wrote:

Hi!

Try this:

=IF(AND(G4="target",OR(J4="target",N4="target"))," II-A",IF(AND(G4="good
standing",J4="good standing",N4="good standing"),"good
standing",IF(AND(G4="good
standing",OR(J4="target",N4="target")),"target","" )))

Biff

"Brenda S." wrote in message
...
I am trying to create a formula where when each of three consitions is met
with a specific response/text string.
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
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

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Trudy Excel Worksheet Functions 5 November 24th 05 12:52 AM Ms. P. Excel Worksheet Functions 8 August 19th 05 07:31 PM Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM Angi Excel Discussion (Misc queries) 7 May 4th 05 07:04 PM Robert AS Excel Worksheet Functions 4 December 2nd 04 11:49 AM

All times are GMT +1. The time now is 05:13 AM. Copyright ©2004-2019 ExcelBanter.