Professor and I cannot figure out why I got this formula incorrect in the assignment. I am including pictures of the instructions and the excel sheet with the formula filled in M2. She will even use my assignment from download and complete the formula the same and it will count it correct for her, however, if I do it the same way it will be wrong. I am operating on Office 365. Thank you for your help.

tommygirl_73703 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.

tommygirl_73703 The image just doesn't make enough clear. Can't even tell for sure what cell is M2 from the image; you didn't include the top and side of the sheet, showing the row and column references. Nor do you show whatever nested IF formula you wrote. Is it possible for you to post the spreadsheet itself?

mathetes I hope all this information helps. There were three cell formulas that gave us trouble that we finally got help on the community to figure out how to get them to say the right information, well except for M2. My professor and I are still having issues figuring out why it is still saying mine is wrong but when she types it in on my document then it is right. So I am including pictures of the instructions for M2 and I am including pictures of the formulas of the other two cells that gave us trouble. I also included a picture of what I have in M2 as well. Hopefully this helps.

tommygirl_73703 In Windows there are many ways to make screenshot (e.g. Win+Shift+S) except mobile phone. And I believe your professor could answer on your questions.

tommygirl_73703 You can't seriously expect those images to be any more helpful than your first. I asked at the start if you could post the spreadsheet itself (it's part of a class, from all appearances, and can't therefore contain any proprietary or confidential info)I also noted you had not shown us the formula you have entered. At the very least, you can copy the formula from cell M2 (or wherever it is) and paste it here. My guess--and it's only a guess, although I don't understand why your professor is unable to diagnose the issue--is that you've left off something very small, like a quote mark (") or two, i.e., something that's easy to overlook especially in a nested IF formula. Any way, if you seriously want help, post the spreadsheet itself or, at the very least, the errant formula.

Structured Reference | Microsoft Community Hub

14 Replies

mathetes
Silver Contributor
Sep 19, 2020
tommygirl_73703

The image just doesn't make enough clear. Can't even tell for sure what cell is M2 from the image; you didn't include the top and side of the sheet, showing the row and column references. Nor do you show whatever nested IF formula you wrote.

Is it possible for you to post the spreadsheet itself?
- tommygirl_73703
  Copper Contributor
  Sep 20, 2020
  mathetes I hope all this information helps. There were three cell formulas that gave us trouble that we finally got help on the community to figure out how to get them to say the right information, well except for M2. My professor and I are still having issues figuring out why it is still saying mine is wrong but when she types it in on my document then it is right. So I am including pictures of the instructions for M2 and I am including pictures of the formulas of the other two cells that gave us trouble. I also included a picture of what I have in M2 as well. Hopefully this helps.
  - mathetes
    Silver Contributor
    Sep 21, 2020
    tommygirl_73703
    
    You can't seriously expect those images to be any more helpful than your first.
    
    I asked at the start if you could post the spreadsheet itself (it's part of a class, from all appearances, and can't therefore contain any proprietary or confidential info)
    I also noted you had not shown us the formula you have entered. At the very least, you can copy the formula from cell M2 (or wherever it is) and paste it here. My guess--and it's only a guess, although I don't understand why your professor is unable to diagnose the issue--is that you've left off something very small, like a quote mark (") or two, i.e., something that's easy to overlook especially in a nested IF formula.
    
    Any way, if you seriously want help, post the spreadsheet itself or, at the very least, the errant formula.

Forum Discussion

Structured Reference

14 Replies

Resources