Operator AND inside function

Post your questions, bug reports and suggestions here for TextMaker 2018 for Windows.

Moderator: SoftMaker Team

Post Reply
jockerfox
Posts: 7
Joined: Mon Jun 25, 2018 7:16 pm

Operator AND inside function

Post by jockerfox » Sun Jul 08, 2018 7:12 pm

Hi.
I hava table 4x10.. ok.

I use this formula:
IF (TABCATEGORIA.$A5 = "A+" & TABCATEGORIA.$A6 = "B+"; "no"; "SI")

but not work. Is not possible use AND operator inside the function? And if not, how can I do ? :roll:

Regards.

LanceGary
Posts: 117
Joined: Sun Dec 09, 2007 9:55 pm

Re: Operator AND inside function

Post by LanceGary » Mon Jul 09, 2018 10:47 am

If you enclose the two conditions being tested by the "If" statement in brackets it should work.

so

if((Table1.#a1<5) & (Table1.#c3<5); "Small"; "Large")

should print "Small" or "Large" depending on the values in Table1. It did in my tests.

Lance

jockerfox
Posts: 7
Joined: Mon Jun 25, 2018 7:16 pm

Re: Operator AND inside function

Post by jockerfox » Mon Jul 09, 2018 4:56 pm

Thank you LanceGary !
Now it works well.

Regards.

Post Reply

Return to “TextMaker 2018 for Windows”