Forum Discussion
Structured Reference
mathetes Ok I have figured out how to post the spreadsheet.
This formula, put into cell M2 as required by the assignment, seems to deliver the desired result.
=IF([@[Academic Technology Training]]="Yes","Completed",IF([@[Service Years]]>2,"Yes","No"))
I've attached the full file with that new formula in place.
I still am mystified as to why you and your instructor have not been entering, or showing you, or why haven't you been showing us, a nested IF formula, since that's what the assignment requires for cell M2? What am I missing in this picture?
You know, I don't want to be crude or cruel about this, but I really don't think you should be satisfied just shrugging your shoulders about it. You're going to school presumably to learn some critical thinking skills--some of which will be applied in writing formulas to derive desired results.
Some more of those critical thinking skills, ideally, would be to learning to do some diagnostic thinking: Why did something go wrong here? What is the cause, as you put it, that made "the wires cross as they did"?
You were working on an assignment that asked for a nested IF formula; you posted a copy of that assignment that clearly spelled out how it should work. You said you and your professor entered formulas; that hers worked, yours didn't. But never did you show us on this site a nested IF that either of you had written. So I'd be very curious if I were in your shoes, as to what you were doing, what she was doing, why both of you apparently missed what was truly a fairly simple formula.
You don't need to answer. But in the interest of your own broader education, I hope you think more deeply about things in general, how they work (or don't), not just about getting to the answer. I'm glad I was able to help in the latter; I encourage you to work at the former.
mathetes You were not missing anything. Your answer was correct. We are not sure what happened that made the wires cross like they did. Thank you so much for your assistance.