Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Or statement help
Oh help!
What I want to do is find which jobs haven't been completed. E to N holds different job categories and the contents of these cells could be Yes Not complete or N/A or blank. I tried this formula and got #value! =IF(OR(E5:N5="Yes",E5:N5="N/A"),TRUE,FALSE) I was then going to filter on False to see what work was outstanding for each person in column D Please help it is Friday and in since early and brain gone mushy! Thank you -- TD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Or statement help
=OR(COUNTIF(E5:N5,"Yes"),COUNTIF(E5:N5,"#N/A"))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TD" wrote in message ... Oh help! What I want to do is find which jobs haven't been completed. E to N holds different job categories and the contents of these cells could be Yes Not complete or N/A or blank. I tried this formula and got #value! =IF(OR(E5:N5="Yes",E5:N5="N/A"),TRUE,FALSE) I was then going to filter on False to see what work was outstanding for each person in column D Please help it is Friday and in since early and brain gone mushy! Thank you -- TD |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Or statement help
Hi Bob and thanks for responding,
Just tried it out, it works fine for the Falses where cells are either not complete or blank but for the Trues where there are Yes and Not Complete in the same row I would like it to return False. Any way to do this? Thanks again -- TD "Bob Phillips" wrote: =OR(COUNTIF(E5:N5,"Yes"),COUNTIF(E5:N5,"#N/A")) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TD" wrote in message ... Oh help! What I want to do is find which jobs haven't been completed. E to N holds different job categories and the contents of these cells could be Yes Not complete or N/A or blank. I tried this formula and got #value! =IF(OR(E5:N5="Yes",E5:N5="N/A"),TRUE,FALSE) I was then going to filter on False to see what work was outstanding for each person in column D Please help it is Friday and in since early and brain gone mushy! Thank you -- TD |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Or statement help
Try this.
=NOT(OR(COUNTIF(E12:N12,"Not Completed"),COUNTIF(E12:N12,""))) "TD" wrote: Hi Bob and thanks for responding, Just tried it out, it works fine for the Falses where cells are either not complete or blank but for the Trues where there are Yes and Not Complete in the same row I would like it to return False. Any way to do this? Thanks again -- TD "Bob Phillips" wrote: =OR(COUNTIF(E5:N5,"Yes"),COUNTIF(E5:N5,"#N/A")) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TD" wrote in message ... Oh help! What I want to do is find which jobs haven't been completed. E to N holds different job categories and the contents of these cells could be Yes Not complete or N/A or blank. I tried this formula and got #value! =IF(OR(E5:N5="Yes",E5:N5="N/A"),TRUE,FALSE) I was then going to filter on False to see what work was outstanding for each person in column D Please help it is Friday and in since early and brain gone mushy! Thank you -- TD |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Or statement help
Do you mean just one (or more) Yes and one (or more) #N/A, or do you mean
all of E5:N5 is either Yes or #N/A? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TD" wrote in message ... Hi Bob and thanks for responding, Just tried it out, it works fine for the Falses where cells are either not complete or blank but for the Trues where there are Yes and Not Complete in the same row I would like it to return False. Any way to do this? Thanks again -- TD "Bob Phillips" wrote: =OR(COUNTIF(E5:N5,"Yes"),COUNTIF(E5:N5,"#N/A")) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TD" wrote in message ... Oh help! What I want to do is find which jobs haven't been completed. E to N holds different job categories and the contents of these cells could be Yes Not complete or N/A or blank. I tried this formula and got #value! =IF(OR(E5:N5="Yes",E5:N5="N/A"),TRUE,FALSE) I was then going to filter on False to see what work was outstanding for each person in column D Please help it is Friday and in since early and brain gone mushy! Thank you -- TD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Help with IF Statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |