QUOTIENT([RemainingRuntime];25)返回#VALUE!错误的原因分析

I’ve run into this exact quirk before—here are the most probable reasons your =QUOTIENT([RemainingRuntime];25) is throwing an error, even with ISNUMBER confirming the field is numeric:

• Invisible non-numeric characters are hiding in your value: ISNUMBER doesn’t catch every hidden character. Sometimes the output from DAYS can pick up leading/trailing spaces, non-breaking spaces, or control characters that make the value look numeric but aren’t recognized as such by QUOTIENT. Fix this by cleaning the value first:

  =QUOTIENT(TRIM(CLEAN([RemainingRuntime])),25)
  

  (Note: Swap semicolons for commas if your locale uses commas as formula separators.)

• Your value is a number stored as text: ISNUMBER can return TRUE for text strings that look like numbers (especially in table columns with automatic formatting). QUOTIENT needs an actual numeric value, not text. Force conversion with the VALUE function:

  =QUOTIENT(VALUE([RemainingRuntime]),25)
  

• Locale mismatch for decimal separators: If your system uses commas for decimals but the DAYS output uses periods (or the other way around), QUOTIENT might misinterpret the value as text. Using VALUE will resolve this by converting the string to a number based on your locale.

A quick sanity check: Replace [RemainingRuntime] with a hardcoded number (e.g., =QUOTIENT(75;25)). If that returns 3 as expected, the problem is definitely how your [RemainingRuntime] field is being processed, not the QUOTIENT function itself.

内容的提问来源于stack exchange，提问作者Jerome Reinländer