If formulas

Formula:

Please Login or Register  to view this content.

Regards, TMS

If C1 is 'No' and C2 is 'No' C3 = 'N/A'
If C1 is 'Yes' C2 will be 'No' C3 = 'N/A'
If C2 is 'Yes' C1 will be 'No' C3 = 'Required'
is the same as
If C1 is 'No' and C2 is 'No' C3 = 'N/A'
If C1 is 'Yes' C2 will be 'No' C3 = 'N/A'
If C1 is 'no' C2 will be 'yes' C3 = 'Required'

so surely you just want to test if c2 is "yes"? =if(c2="yes","required",""n/a")

Being pedantic, this is what you have asked for:

Formula:

Please Login or Register  to view this content.

In this instance, if C1 and C2 are both "yes", you get "not valid"

You should maybe allow for the scenario when one or both of the cells is blank:

Formula:

Please Login or Register  to view this content.

Regards, TMS

Duplicate post

http://www.excelforum.com/excel-form...f-formula.html

Now why would you do that, when we were getting on so nicely. Naughty.

Is this resolved?



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

You're welcome.

Trouble is, the new thread DOES look very like the original.

I would have thought that,based on the suggestions here, you would be able to adapt the formula(e) to meet the additional requirement.

So that people understand that the new thread is not a duplicate, I suggest you change the Thread Title ... maybe add "Part 2" or something.

And, for me, it always helps to understand the problem/requirement if you post a sample workbook.

And finally, in the new thread, post the link of the original thread a) for background and b) to show that this is a different thread/requirement.


Please mark this thread solved as indicated in my last post.

Regards, TMS