1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • #NAME?

    From GARYWC@21:1/5 to All on Sun Oct 24 15:46:22 2021
    What is the syntax error in this formula?

    =IF(A4<=(B4+D4)*0.1,”Lower“,IF(A4>=(B4+D4)*0.9,”Upper”,” “))


    #NAME is still being displayed

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From zvkmpw@21:1/5 to GARYWC on Mon Oct 25 13:11:10 2021
    On Sunday, October 24, 2021 at 3:46:24 PM UTC-7, GARYWC wrote:
    What is the syntax error in this formula?

    =IF(A4<=(B4+D4)*0.1,”Lower“,IF(A4>=(B4+D4)*0.9,”Upper”,” “))

    The double-quote characters are the curly-style quotes. These are useful in Word documents, but Excel doesn't consider them to be the same as a straight quote: " "

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From GARYWC@21:1/5 to All on Mon Oct 25 13:41:24 2021
    The curly quotes came from Excel in the HINDI (India) version of Office 2007

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From zvkmpw@21:1/5 to GARYWC on Tue Oct 26 10:51:12 2021
    On Monday, October 25, 2021 at 1:41:26 PM UTC-7, GARYWC wrote:
    The curly quotes came from Excel in the HINDI (India) version of Office 2007

    This is curious.

    At any rate, you now hopefully have enough information to circumvent the error.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)