I don't know the correct terminology to use to research how to fix this problem. Please bear with me.
I want to satisfy two If statements, then substitute one of two answers in a cell.
Let's say that cell D11 says "Yes" and D12 Says "No"
How do I create a formula that puts N/A in a cell if D11 is Yes and D12 is No or puts "Correct" in the cell if both conditions are not met?
I know how to do it with one if statement
*=IF(D11 = "Yes", "N/A")* but I can't figure out how to say
If D11 = "Yes" and D12 = "No", "N/A" and, if not, "Correct"
Thank you so much. I just couldn't figure out how to combine the two statements.
I took the logic from your response and added it to my real formula and it worked great but I still want to tweak it a bit and need your help.
The statement below says if D11 = Yes and D12 = No and the month from the date in cell I5 is less than 7, write 1/1/2006 and if the date is more than 7, write 7/1/2006.
The formula works great. How can I tweak it a bit to satisfy my real aim which is to have the contents of the cell to change to 1/1/2006 or 7/1/2006 or N/A depending on the contents of both cells, D11 and D12. If either D11 or D12 is "Yes" then I want the date to changed as indicated above, but if D11 and D12 are both "No" then I want the cell to state "N/A".
My eternal gratitude. Thank you very much.
You seem to be have the basic Idea of 'IF...THEN which is:
'If this is true, DO this, else DO this'
Now we move on to truth tables:
AND means both must meet the criteria for the test to pass, otherwise the test fails.
OR means one must match criteria for the test to pass, if neither matches then fail.
So we have 1st test:
If (D11="no" _AND_ D12="no") is True (both are NO), Do (echo) "N/A".
1st test failed? Do 2nd test...
If (D11="yes" _OR_ D12 ='yes") check date. Greater than 7?, Do this, else Do this.
And here 'tis with the correct syntax:
It worked. Thank you so much.
I understand the logic but how do you learn how to set the formula up?
I know how to do the basics in Excel and there is so much that Excel can do that I will never need to learn.
Is there are simple course that someone can take through this Forum or a book that can help me learn simply how to manipulate dates.
Hi, Here's a link to experts-exchange, another board which has ALL apps including Excel, Word, VBA, etc etc!
There are currently 3 users browsing this thread. (0 members and 3 guests)