Numbers MAX Formula unexpected result
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: