Share via

MAX function not working for me

Anonymous
2022-07-13T15:33:41+00:00

It seems the max function isn't working in Excel online for me. I followed MAX function.

I am getting the format correctly.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2022-07-13T15:38:16+00:00

    Did you remember to format the cell as general or number and to use an = as the first character? Copy what you have from the formula bar and paste it in a message to show your usage.

    Was this answer helpful?

    0 comments No comments
  2. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2022-07-13T15:38:00+00:00

    In what way specifically is it not working? If it's returning 0 when you don't think it should, your numbers are probably stored as text.

    Was this answer helpful?

    0 comments No comments