Combining two IF functions in one cell using Excel 2010
up vote
4
down vote
favorite
I have these two IF functions that work correctly on their own. I need to combine the two into one cell but can't seem to get them to work. Any help would be appreciated. And thanks in advance.
Screen capture 1
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted")
Screen capture 2
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
I've tried the following combos without any luck.
This one results in screen capture 3
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted")=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
This combo results in a #VALUE! Error in the cell:
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted"),IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
And this screen capture is me manually updating the cells to show what I need them to show, screen capture 4
microsoft-excel worksheet-function
edited Dec 26 '15 at 23:46
Hennes
58.7k792141
asked Sep 16 '13 at 10:31
Bryce
23114
add a comment |
up vote
4
down vote
favorite
I have these two IF functions that work correctly on their own. I need to combine the two into one cell but can't seem to get them to work. Any help would be appreciated. And thanks in advance.
Screen capture 1
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted")
Screen capture 2
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
I've tried the following combos without any luck.
This one results in screen capture 3
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted")=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
This combo results in a #VALUE! Error in the cell:
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted"),IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
And this screen capture is me manually updating the cells to show what I need them to show, screen capture 4
microsoft-excel worksheet-function
edited Dec 26 '15 at 23:46
Hennes
58.7k792141
asked Sep 16 '13 at 10:31
Bryce
23114
i16.photobucket.com/albums/b43/bakdawg/Capture1_zps5446303f.png
– Bryce
Sep 16 '13 at 10:37
i16.photobucket.com/albums/b43/bakdawg/Capture2_zps7a9fcc8d.png
– Bryce
Sep 16 '13 at 10:38
add a comment |
up vote
4
down vote
favorite
up vote
4
down vote
favorite
I have these two IF functions that work correctly on their own. I need to combine the two into one cell but can't seem to get them to work. Any help would be appreciated. And thanks in advance.
Screen capture 1
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted")
Screen capture 2
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
I've tried the following combos without any luck.
This one results in screen capture 3
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted")=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
This combo results in a #VALUE! Error in the cell:
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted"),IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
And this screen capture is me manually updating the cells to show what I need them to show, screen capture 4
microsoft-excel worksheet-function
edited Dec 26 '15 at 23:46
Hennes
58.7k792141
asked Sep 16 '13 at 10:31
Bryce
23114
I have these two IF functions that work correctly on their own. I need to combine the two into one cell but can't seem to get them to work. Any help would be appreciated. And thanks in advance.
Screen capture 1
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted")
Screen capture 2
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
I've tried the following combos without any luck.
This one results in screen capture 3
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted")=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
This combo results in a #VALUE! Error in the cell:
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted"),IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted")
And this screen capture is me manually updating the cells to show what I need them to show, screen capture 4
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited Dec 26 '15 at 23:46
Hennes
58.7k792141
asked Sep 16 '13 at 10:31
Bryce
23114
edited Dec 26 '15 at 23:46
Hennes
58.7k792141
asked Sep 16 '13 at 10:31
Bryce
23114
edited Dec 26 '15 at 23:46
Hennes
58.7k792141
edited Dec 26 '15 at 23:46
Hennes
58.7k792141
edited Dec 26 '15 at 23:46
Hennes
58.7k792141
58.7k792141
asked Sep 16 '13 at 10:31
Bryce
23114
asked Sep 16 '13 at 10:31
Bryce
23114
asked Sep 16 '13 at 10:31
Bryce
23114
23114
i16.photobucket.com/albums/b43/bakdawg/Capture1_zps5446303f.png
– Bryce
Sep 16 '13 at 10:37
i16.photobucket.com/albums/b43/bakdawg/Capture2_zps7a9fcc8d.png
– Bryce
Sep 16 '13 at 10:38
add a comment |
i16.photobucket.com/albums/b43/bakdawg/Capture1_zps5446303f.png
– Bryce
Sep 16 '13 at 10:37
i16.photobucket.com/albums/b43/bakdawg/Capture2_zps7a9fcc8d.png
– Bryce
Sep 16 '13 at 10:38
i16.photobucket.com/albums/b43/bakdawg/Capture1_zps5446303f.png
– Bryce
Sep 16 '13 at 10:37
i16.photobucket.com/albums/b43/bakdawg/Capture1_zps5446303f.png
– Bryce
Sep 16 '13 at 10:37
i16.photobucket.com/albums/b43/bakdawg/Capture2_zps7a9fcc8d.png
– Bryce
Sep 16 '13 at 10:38
i16.photobucket.com/albums/b43/bakdawg/Capture2_zps7a9fcc8d.png
– Bryce
Sep 16 '13 at 10:38
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
Those are really long IF if you ask me!
But if I understand what you're trying to do...
It will be either this:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted"))
Or this:
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted", IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted"))
It depends on what you want to check for first.
EDIT: After reconsidering the formula, maybe this would be better:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(Z5="Not Attempted","Not Attempted"))
answered Sep 16 '13 at 10:42
Jerry
4,608827
Wow, thanks for the quick response! Haha yes they are really long but it's what I have to work with...The first one you posted is VERY close and the second one has a few correct. But on the first one if you see on my screen shot I highlighted in yellow should show "Not Attempted" as they are an O-1 Pilot who is not exempt in the rule in the formula and have not completed it in column Z. i16.photobucket.com/albums/b43/bakdawg/Capture7_zpsba4c9714.png
– Bryce
Sep 16 '13 at 12:09
@Bryce Oh that makes much more sense now! I admit it didn't make much sense initially haha ^^; Okay, logically, every person who is not exempt and has "Not attempted" should get "Not attempted", right? Currently, the formula only checks forIntelfor this particular category. The formula can be made shorter by checking all personnel, not justIntelby removing the AND in the second formula. I added that formula in my answer. See if this works now! ^^
– Jerry
Sep 16 '13 at 12:22
1
To help clarifiy what I'm trying to accomplish. If their position is Intel they have to have a date in column Z which should show False in column U. If column Z shows not completed then column U needs to show Not Completed
– Bryce
Sep 16 '13 at 12:25
The other positions (pilot, sensor, admin) need to show a date in column Z which again should show false in column U. There are several ranks that are exempt (all those shown in the formula) and they should show not required if they have a Not Completed in their respective column Z. And if they aren't exempt based off of rank and have a Not Completed in column Z then column U should also show Not Completed
– Bryce
Sep 16 '13 at 12:26
Jerry - I think that works!!! I will try to check it against my entire document but so far it looks good. Thank you so much for the help! -Bryce
– Bryce
Sep 16 '13 at 12:33
|
show 1 more comment
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
Those are really long IF if you ask me!
But if I understand what you're trying to do...
It will be either this:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted"))
Or this:
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted", IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted"))
It depends on what you want to check for first.
EDIT: After reconsidering the formula, maybe this would be better:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(Z5="Not Attempted","Not Attempted"))
answered Sep 16 '13 at 10:42
Jerry
4,608827
Wow, thanks for the quick response! Haha yes they are really long but it's what I have to work with...The first one you posted is VERY close and the second one has a few correct. But on the first one if you see on my screen shot I highlighted in yellow should show "Not Attempted" as they are an O-1 Pilot who is not exempt in the rule in the formula and have not completed it in column Z. i16.photobucket.com/albums/b43/bakdawg/Capture7_zpsba4c9714.png
– Bryce
Sep 16 '13 at 12:09
@Bryce Oh that makes much more sense now! I admit it didn't make much sense initially haha ^^; Okay, logically, every person who is not exempt and has "Not attempted" should get "Not attempted", right? Currently, the formula only checks forIntelfor this particular category. The formula can be made shorter by checking all personnel, not justIntelby removing the AND in the second formula. I added that formula in my answer. See if this works now! ^^
– Jerry
Sep 16 '13 at 12:22
1
To help clarifiy what I'm trying to accomplish. If their position is Intel they have to have a date in column Z which should show False in column U. If column Z shows not completed then column U needs to show Not Completed
– Bryce
Sep 16 '13 at 12:25
The other positions (pilot, sensor, admin) need to show a date in column Z which again should show false in column U. There are several ranks that are exempt (all those shown in the formula) and they should show not required if they have a Not Completed in their respective column Z. And if they aren't exempt based off of rank and have a Not Completed in column Z then column U should also show Not Completed
– Bryce
Sep 16 '13 at 12:26
Jerry - I think that works!!! I will try to check it against my entire document but so far it looks good. Thank you so much for the help! -Bryce
– Bryce
Sep 16 '13 at 12:33
|
show 1 more comment
up vote
1
down vote
accepted
Those are really long IF if you ask me!
But if I understand what you're trying to do...
It will be either this:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted"))
Or this:
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted", IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted"))
It depends on what you want to check for first.
EDIT: After reconsidering the formula, maybe this would be better:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(Z5="Not Attempted","Not Attempted"))
answered Sep 16 '13 at 10:42
Jerry
4,608827
Wow, thanks for the quick response! Haha yes they are really long but it's what I have to work with...The first one you posted is VERY close and the second one has a few correct. But on the first one if you see on my screen shot I highlighted in yellow should show "Not Attempted" as they are an O-1 Pilot who is not exempt in the rule in the formula and have not completed it in column Z. i16.photobucket.com/albums/b43/bakdawg/Capture7_zpsba4c9714.png
– Bryce
Sep 16 '13 at 12:09
@Bryce Oh that makes much more sense now! I admit it didn't make much sense initially haha ^^; Okay, logically, every person who is not exempt and has "Not attempted" should get "Not attempted", right? Currently, the formula only checks forIntelfor this particular category. The formula can be made shorter by checking all personnel, not justIntelby removing the AND in the second formula. I added that formula in my answer. See if this works now! ^^
– Jerry
Sep 16 '13 at 12:22
1
To help clarifiy what I'm trying to accomplish. If their position is Intel they have to have a date in column Z which should show False in column U. If column Z shows not completed then column U needs to show Not Completed
– Bryce
Sep 16 '13 at 12:25
The other positions (pilot, sensor, admin) need to show a date in column Z which again should show false in column U. There are several ranks that are exempt (all those shown in the formula) and they should show not required if they have a Not Completed in their respective column Z. And if they aren't exempt based off of rank and have a Not Completed in column Z then column U should also show Not Completed
– Bryce
Sep 16 '13 at 12:26
Jerry - I think that works!!! I will try to check it against my entire document but so far it looks good. Thank you so much for the help! -Bryce
– Bryce
Sep 16 '13 at 12:33
|
show 1 more comment
up vote
1
down vote
accepted
up vote
1
down vote
accepted
Those are really long IF if you ask me!
But if I understand what you're trying to do...
It will be either this:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted"))
Or this:
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted", IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted"))
It depends on what you want to check for first.
EDIT: After reconsidering the formula, maybe this would be better:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(Z5="Not Attempted","Not Attempted"))
answered Sep 16 '13 at 10:42
Jerry
4,608827
Those are really long IF if you ask me!
But if I understand what you're trying to do...
It will be either this:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted"))
Or this:
=IF(AND((D5="Intel"),(Z5="Not Attempted")),"Not Attempted", IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", "Not Attempted"))
It depends on what you want to check for first.
EDIT: After reconsidering the formula, maybe this would be better:
=IF(AND(OR(D5="Pilot", D5="Sensor", D5="Admin"),(Z5="Not Attempted"),OR(C5="E-1",C5="E-2",C5="E-3",C5="E-7",C5="E-8",C5="E-9",C5="O-4",C5="O-5",C5="O-6")),"Not Required", IF(Z5="Not Attempted","Not Attempted"))
answered Sep 16 '13 at 10:42
Jerry
4,608827
edited Sep 16 '13 at 12:20
answered Sep 16 '13 at 10:42
Jerry
4,608827
answered Sep 16 '13 at 10:42
Jerry
4,608827
answered Sep 16 '13 at 10:42
Jerry
4,608827
4,608827
Wow, thanks for the quick response! Haha yes they are really long but it's what I have to work with...The first one you posted is VERY close and the second one has a few correct. But on the first one if you see on my screen shot I highlighted in yellow should show "Not Attempted" as they are an O-1 Pilot who is not exempt in the rule in the formula and have not completed it in column Z. i16.photobucket.com/albums/b43/bakdawg/Capture7_zpsba4c9714.png
– Bryce
Sep 16 '13 at 12:09
@Bryce Oh that makes much more sense now! I admit it didn't make much sense initially haha ^^; Okay, logically, every person who is not exempt and has "Not attempted" should get "Not attempted", right? Currently, the formula only checks forIntelfor this particular category. The formula can be made shorter by checking all personnel, not justIntelby removing the AND in the second formula. I added that formula in my answer. See if this works now! ^^
– Jerry
Sep 16 '13 at 12:22
1
To help clarifiy what I'm trying to accomplish. If their position is Intel they have to have a date in column Z which should show False in column U. If column Z shows not completed then column U needs to show Not Completed
– Bryce
Sep 16 '13 at 12:25
The other positions (pilot, sensor, admin) need to show a date in column Z which again should show false in column U. There are several ranks that are exempt (all those shown in the formula) and they should show not required if they have a Not Completed in their respective column Z. And if they aren't exempt based off of rank and have a Not Completed in column Z then column U should also show Not Completed
– Bryce
Sep 16 '13 at 12:26
Jerry - I think that works!!! I will try to check it against my entire document but so far it looks good. Thank you so much for the help! -Bryce
– Bryce
Sep 16 '13 at 12:33
|
show 1 more comment
Wow, thanks for the quick response! Haha yes they are really long but it's what I have to work with...The first one you posted is VERY close and the second one has a few correct. But on the first one if you see on my screen shot I highlighted in yellow should show "Not Attempted" as they are an O-1 Pilot who is not exempt in the rule in the formula and have not completed it in column Z. i16.photobucket.com/albums/b43/bakdawg/Capture7_zpsba4c9714.png
– Bryce
Sep 16 '13 at 12:09
@Bryce Oh that makes much more sense now! I admit it didn't make much sense initially haha ^^; Okay, logically, every person who is not exempt and has "Not attempted" should get "Not attempted", right? Currently, the formula only checks forIntelfor this particular category. The formula can be made shorter by checking all personnel, not justIntelby removing the AND in the second formula. I added that formula in my answer. See if this works now! ^^
– Jerry
Sep 16 '13 at 12:22
1
To help clarifiy what I'm trying to accomplish. If their position is Intel they have to have a date in column Z which should show False in column U. If column Z shows not completed then column U needs to show Not Completed
– Bryce
Sep 16 '13 at 12:25
The other positions (pilot, sensor, admin) need to show a date in column Z which again should show false in column U. There are several ranks that are exempt (all those shown in the formula) and they should show not required if they have a Not Completed in their respective column Z. And if they aren't exempt based off of rank and have a Not Completed in column Z then column U should also show Not Completed
– Bryce
Sep 16 '13 at 12:26
Jerry - I think that works!!! I will try to check it against my entire document but so far it looks good. Thank you so much for the help! -Bryce
– Bryce
Sep 16 '13 at 12:33
Wow, thanks for the quick response! Haha yes they are really long but it's what I have to work with...The first one you posted is VERY close and the second one has a few correct. But on the first one if you see on my screen shot I highlighted in yellow should show "Not Attempted" as they are an O-1 Pilot who is not exempt in the rule in the formula and have not completed it in column Z. i16.photobucket.com/albums/b43/bakdawg/Capture7_zpsba4c9714.png
– Bryce
Sep 16 '13 at 12:09
Wow, thanks for the quick response! Haha yes they are really long but it's what I have to work with...The first one you posted is VERY close and the second one has a few correct. But on the first one if you see on my screen shot I highlighted in yellow should show "Not Attempted" as they are an O-1 Pilot who is not exempt in the rule in the formula and have not completed it in column Z. i16.photobucket.com/albums/b43/bakdawg/Capture7_zpsba4c9714.png
– Bryce
Sep 16 '13 at 12:09
@Bryce Oh that makes much more sense now! I admit it didn't make much sense initially haha ^^; Okay, logically, every person who is not exempt and has "Not attempted" should get "Not attempted", right? Currently, the formula only checks for
Intel for this particular category. The formula can be made shorter by checking all personnel, not just Intel by removing the AND in the second formula. I added that formula in my answer. See if this works now! ^^– Jerry
Sep 16 '13 at 12:22
@Bryce Oh that makes much more sense now! I admit it didn't make much sense initially haha ^^; Okay, logically, every person who is not exempt and has "Not attempted" should get "Not attempted", right? Currently, the formula only checks for
Intel for this particular category. The formula can be made shorter by checking all personnel, not just Intel by removing the AND in the second formula. I added that formula in my answer. See if this works now! ^^– Jerry
Sep 16 '13 at 12:22
1
1
To help clarifiy what I'm trying to accomplish. If their position is Intel they have to have a date in column Z which should show False in column U. If column Z shows not completed then column U needs to show Not Completed
– Bryce
Sep 16 '13 at 12:25
To help clarifiy what I'm trying to accomplish. If their position is Intel they have to have a date in column Z which should show False in column U. If column Z shows not completed then column U needs to show Not Completed
– Bryce
Sep 16 '13 at 12:25
The other positions (pilot, sensor, admin) need to show a date in column Z which again should show false in column U. There are several ranks that are exempt (all those shown in the formula) and they should show not required if they have a Not Completed in their respective column Z. And if they aren't exempt based off of rank and have a Not Completed in column Z then column U should also show Not Completed
– Bryce
Sep 16 '13 at 12:26
The other positions (pilot, sensor, admin) need to show a date in column Z which again should show false in column U. There are several ranks that are exempt (all those shown in the formula) and they should show not required if they have a Not Completed in their respective column Z. And if they aren't exempt based off of rank and have a Not Completed in column Z then column U should also show Not Completed
– Bryce
Sep 16 '13 at 12:26
Jerry - I think that works!!! I will try to check it against my entire document but so far it looks good. Thank you so much for the help! -Bryce
– Bryce
Sep 16 '13 at 12:33
Jerry - I think that works!!! I will try to check it against my entire document but so far it looks good. Thank you so much for the help! -Bryce
– Bryce
Sep 16 '13 at 12:33
|
show 1 more comment
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f645999%2fcombining-two-if-functions-in-one-cell-using-excel-2010%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
i16.photobucket.com/albums/b43/bakdawg/Capture1_zps5446303f.png
– Bryce
Sep 16 '13 at 10:37
i16.photobucket.com/albums/b43/bakdawg/Capture2_zps7a9fcc8d.png
– Bryce
Sep 16 '13 at 10:38