Excel get max between two cells (NOT RANGE)

问题:

The MAX function gives me the maximum number in a range but what if my cells are not in a range?

If we have in A1 the number 10m and in D11 the number 8m how can we find the MAX number between these two cells?

回答1:

You can specify a set of cells instead of a range:

max(A1;A4;A10;A12)

In your case:

max(A1;D11)