Numbers MAX Formula unexpected result Goal: Display MAX (greatest) current result from column which keeps growing
Current issue: I can have all current entries regarded, however a newer, higher value gets ignored.
Attempts to set up : =(MAX(NAME OF COLUMN)) Returns !. =(MAX(Cell_1:Last_cell)) returns all existing values and ignores the new ones.
Also changed: All cells refer to decimal numbers with 2 digits.
What do I have to do to make the formula work?
Frustratingly enough I am working with an Apple template and have copied 1:1 the format that they use…
I would just give max() the column to work with and it will take the max of all values found. The only danger is if someone adds data further down the column...
See: