Screen Shot 2019-02-08 at 11.08.21 PM.png
Trying to help my wife with a spreadsheet for her class that will check a score to see if it is passing, if it is then keep that score, if not go back to the last weeks score. I have done this the only way I have found in a long drawn out process. I'm trying to figure out how to combine all of these in one formula
D11 =IF(C11>70, "PASS", "FAIL")
E11 =IF(ISNUMBER(SEARCH("PASS",D11)),C11,A11-6)
F11 =TEXT(E11,"m/d/yy")
G11 =VLOOKUP(F11,B4:C34,2,0)
H11 =IF(E11<101, E11, G11)
The desired results are there, just in multiple cells. Yes, I'm an excel newbie
Thanks for any and all help on this!
Bookmarks