MAX function, formulas in cells in range

Lisa Huggler

I am using the MAX function to pull the max value from multiple cells. Some cells have formulas and currently are not pulling into the MAX formula. How can I fix this?

Kelly Moore

Hey @Lisa Huggler

Often formulas pull data into a cell but, in the process, make a number behave as text instead of a number. The VALUE function tells a number to behave as a number instead of text. You could try wrapping a VALUE function around your entire formula in the cells that are not being pulled in. Sometimes you can add the VALUE as criteria within the MAX formula, depending on the data and functions being used within the formula.

If used within cells not being pulled in:

=VALUE(Your entire formula, including all parentheses)

If the above doesn't work, is it possible for you to give us a screenshot of the sheet and your max formula? This will help us narrow down what might be the issue.

Kelly