Topic Options
#57259 - 04/18/18 11:21 AM Gridview formula help please
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
(142.112.25.244)
Can someone help me please with this gridview formula?

I was successful in this formula:

IF({Tax Group}= " ON",{GST/HST},0)

However, now I want to add if the tax group is ON OR QC.

IF({Tax Group}= " ON",
OR({Tax Group}= " QC",
{GST/HST},0)

But when I do this my evaluation fails. I've tried various ways to add the OR statement but I'm doing something wrong.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#57260 - 04/18/18 11:23 AM Re: Gridview formula help please [Re: SusanTennier]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
(184.70.7.174)
Code:
IF(
   OR(
        {Tax Group}= " ON",
        {Tax Group}= " QC"
   ),
{GST/HST}
,
0)
_________________________
Andrew Bates

Top
#57261 - 04/18/18 11:25 AM Re: Gridview formula help please [Re: Retired_Guy]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
(142.112.25.244)
Thanks!
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Christa_Meissner), 132 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1873 Members
5 Forums
14553 Topics
71030 Posts

Max Online: 432 @ 01/20/25 10:17 PM
October
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31