Message-ID:

"jackpot: you may have an unnecessary change record" -- message from "diff"

computers / microsoft.public.excel.misc / Re: What is the syntax error in this formula?

#NAME?

<2d06475b-deb3-418a-85cf-e4e160fe4d50n@googlegroups.com>

https://www.novabbs.com/computers/article-flat.php?id=150&group=microsoft.public.excel.misc#150

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:a05:620a:170d:: with SMTP id az13mr10761127qkb.505.1635115583044;
Sun, 24 Oct 2021 15:46:23 -0700 (PDT)
X-Received: by 2002:a25:9748:: with SMTP id h8mr14371129ybo.111.1635115582814;
Sun, 24 Oct 2021 15:46:22 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Sun, 24 Oct 2021 15:46:22 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=108.254.79.9; posting-account=zo8_mgkAAABPL_XT7A5EvS2_1pAZtr9-
NNTP-Posting-Host: 108.254.79.9
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <2d06475b-deb3-418a-85cf-e4e160fe4d50n@googlegroups.com>
Subject: #NAME?
From: gcott...@earthlink.net (GARYWC)
Injection-Date: Sun, 24 Oct 2021 22:46:23 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 6

by: GARYWC - Sun, 24 Oct 2021 22:46 UTC

Re: #NAME?

<d50310a7-ee66-4f01-b241-c7ee2ad75c50n@googlegroups.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=151&group=microsoft.public.excel.misc#151

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:a05:622a:170c:: with SMTP id h12mr20798405qtk.46.1635192671252;
Mon, 25 Oct 2021 13:11:11 -0700 (PDT)
X-Received: by 2002:a25:b906:: with SMTP id x6mr17444731ybj.40.1635192671025;
Mon, 25 Oct 2021 13:11:11 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Mon, 25 Oct 2021 13:11:10 -0700 (PDT)
In-Reply-To: <2d06475b-deb3-418a-85cf-e4e160fe4d50n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2601:644:4201:28f0:91a5:88ed:ca0d:b8d2;
posting-account=ohH3mgoAAABnYzdfW6MrzNavjcyUM7Nu
NNTP-Posting-Host: 2601:644:4201:28f0:91a5:88ed:ca0d:b8d2
References: <2d06475b-deb3-418a-85cf-e4e160fe4d50n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d50310a7-ee66-4f01-b241-c7ee2ad75c50n@googlegroups.com>
Subject: Re: #NAME?
From: zvk...@comcast.net (zvkmpw)
Injection-Date: Mon, 25 Oct 2021 20:11:11 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 8

by: zvkmpw - Mon, 25 Oct 2021 20:11 UTC

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: " "

What is the syntax error in this formula?

<b11f75db-d73e-4279-99fc-4f432626fb5an@googlegroups.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=152&group=microsoft.public.excel.misc#152

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:ae9:e8cb:: with SMTP id a194mr15740748qkg.197.1635194484503;
Mon, 25 Oct 2021 13:41:24 -0700 (PDT)
X-Received: by 2002:a25:7c81:: with SMTP id x123mr18793343ybc.185.1635194484322;
Mon, 25 Oct 2021 13:41:24 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Mon, 25 Oct 2021 13:41:24 -0700 (PDT)
In-Reply-To: <d50310a7-ee66-4f01-b241-c7ee2ad75c50n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=108.254.79.9; posting-account=zo8_mgkAAABPL_XT7A5EvS2_1pAZtr9-
NNTP-Posting-Host: 108.254.79.9
References: <2d06475b-deb3-418a-85cf-e4e160fe4d50n@googlegroups.com> <d50310a7-ee66-4f01-b241-c7ee2ad75c50n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <b11f75db-d73e-4279-99fc-4f432626fb5an@googlegroups.com>
Subject: What is the syntax error in this formula?
From: gcott...@earthlink.net (GARYWC)
Injection-Date: Mon, 25 Oct 2021 20:41:24 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 0

by: GARYWC - Mon, 25 Oct 2021 20:41 UTC

Re: What is the syntax error in this formula?

<14341944-ef17-4466-b707-ee8d7afa56c5n@googlegroups.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=154&group=microsoft.public.excel.misc#154

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:a05:622a:4:: with SMTP id x4mr9711727qtw.185.1635270673290;
Tue, 26 Oct 2021 10:51:13 -0700 (PDT)
X-Received: by 2002:a25:cb44:: with SMTP id b65mr21768068ybg.237.1635270672869;
Tue, 26 Oct 2021 10:51:12 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Tue, 26 Oct 2021 10:51:12 -0700 (PDT)
In-Reply-To: <b11f75db-d73e-4279-99fc-4f432626fb5an@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2601:644:4201:28f0:6003:3d3f:2704:f433;
posting-account=ohH3mgoAAABnYzdfW6MrzNavjcyUM7Nu
NNTP-Posting-Host: 2601:644:4201:28f0:6003:3d3f:2704:f433
References: <2d06475b-deb3-418a-85cf-e4e160fe4d50n@googlegroups.com>
<d50310a7-ee66-4f01-b241-c7ee2ad75c50n@googlegroups.com> <b11f75db-d73e-4279-99fc-4f432626fb5an@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <14341944-ef17-4466-b707-ee8d7afa56c5n@googlegroups.com>
Subject: Re: What is the syntax error in this formula?
From: zvk...@comcast.net (zvkmpw)
Injection-Date: Tue, 26 Oct 2021 17:51:13 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 5

by: zvkmpw - Tue, 26 Oct 2021 17:51 UTC

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.

Subject	Author
#NAME?	GARYWC
Re: #NAME?	zvkmpw
What is the syntax error in this formula?	GARYWC
Re: What is the syntax error in this formula?	zvkmpw