max function for less than or greater than values

Copper Contributor



I am dealing with a concentration dataset where there are < or > symbols involved in the dataset. The max formula with implicit is not working for me. Thoughts for resolution?

1 Reply


It depends on how you want to treat a value such as ">100". If you want to count that as 100, you could do the following.

Let's say the data are in A2:A100.


=MAX(--SUBSTITUTE(SUBSTITUTE(A2:A100, ">", ""), "<", ""))


If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.