#1   Report Post  
Old December 9th 05, 09:47 PM posted to microsoft.public.excel.worksheet.functions
Brenda S.
 
Posts: n/a
Default Nested function

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!

  #2   Report Post  
Old December 10th 05, 04:37 AM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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.
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!



  #3   Report Post  
Old December 12th 05, 08:36 PM posted to microsoft.public.excel.worksheet.functions
Brenda S.
 
Posts: n/a
Default 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"
groups. Thanks again for your quick reply! BBS

=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.
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!






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested IF with OR Function Trudy Excel Worksheet Functions 5 November 24th 05 12:52 AM
Nested "If" Function Ms. P. Excel Worksheet Functions 8 August 19th 05 07:31 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
Countif Function -Nested Angi Excel Discussion (Misc queries) 7 May 4th 05 07:04 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 11:49 AM


All times are GMT +1. The time now is 05:13 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017