Forum Discussion
max function for less than or greater than values
Hello, 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?
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.