All functions in workbook quit working

[John_Whin]

I've got Vlookup and other functions that have completely quit working throughout workbook. Using Excel 2016 on PC.

In this example K17 should return "W". I've highlighted the cell above just for clarity. So if there is no score the cell is blank, if a win then "W", if Loss "L".

Even if I change the input values in cells above, the function that worked yesterday does not work. For example today if I enter a 5 in J15 (a clear loss) the "W" remains.

I've saved as and have same problem, have restarted computer, same problem.

Thanks

 

[John_Whin]

never mind, workbook somehow changed calculation to manual, again