¿ªÔÆÌåÓý

  1. Tablesmith
  2. Topics

Odd error

 

Hello,
The table I have been working on has a strange error. This is the formula and the output.
1,Is 17>=23? {If~17>=23?Yes/No}. Then, Is 17<=23? {If~17<=23?No/Yes}

Is 17>=23? No. Then, Is 17<=23? No

If I swap the <> I get the result I want, but the logic is wrong. Other <> statements work fine elsewhere in the same table. Am I crazy, SOL, or other?
-Mark
 

The only error I can see is in the second statement.
{If~17<=23?No/Yes}
should be
{If~17<=23?Yes/No}

Vance

----- Original Message -----
From: "Lemme" <sylimaahn@...>


Hello,
The table I have been working on has a strange error. This is the formula and the output.
1,Is 17>=23? {If~17>=23?Yes/No}. Then, Is 17<=23? {If~17<=23?No/Yes}

Is 17>=23? No. Then, Is 17<=23? No

If I swap the <> I get the result I want, but the logic is wrong. Other <> statements work fine elsewhere in the same table. Am I crazy, SOL, or other?
-Mark
 

Unfortunately, the second statement is the output from TS from running the first statement.

--- In TableSmith@..., "Vance" <clubvance@...> wrote:

The only error I can see is in the second statement.
{If~17<=23?No/Yes}
should be
{If~17<=23?Yes/No}

Vance


----- Original Message -----
From: "Lemme" <sylimaahn@...>


Hello,
The table I have been working on has a strange error. This is the formula
and the output.
1,Is 17>=23? {If~17>=23?Yes/No}. Then, Is 17<=23? {If~17<=23?No/Yes}

Is 17>=23? No. Then, Is 17<=23? No

If I swap the <> I get the result I want, but the logic is wrong. Other <>
statements work fine elsewhere in the same table. Am I crazy, SOL, or
other?
-Mark
 

Vance is talking about the statement in the TS code. If the script says
this:

1,Is 17>=23? {If~17>=23?Yes/No}. Then, Is 17<=23? {If~17<=23?Yes/No}

The result is this:

Is 17>=23? No. Then, Is 17<=23? Yes

The second "If" as originally written says "If 17 is less than or equal to
23, then print 'no', otherwise print 'yes'." Since 17 is less than 23, it's
printing 'no' like it's being told.


On Thu, Mar 28, 2013 at 8:00 AM, Lemme <sylimaahn@...> wrote:

**


Unfortunately, the second statement is the output from TS from running the
first statement.

--- In TableSmith@..., "Vance" <clubvance@...> wrote:

The only error I can see is in the second statement.
{If~17<=23?No/Yes}
should be
{If~17<=23?Yes/No}

Vance


----- Original Message -----
From: "Lemme" <sylimaahn@...>


Hello,
The table I have been working on has a strange error. This is the
formula
and the output.
1,Is 17>=23? {If~17>=23?Yes/No}. Then, Is 17<=23? {If~17<=23?No/Yes}

Is 17>=23? No. Then, Is 17<=23? No

If I swap the <> I get the result I want, but the logic is wrong.
Other <>
statements work fine elsewhere in the same table. Am I crazy, SOL, or
other?
-Mark



[Non-text portions of this message have been removed]
 

Thanks everyone,
For some reason I was stuck looking at the logic wrong. I guess I just needed a few days without {If~ statements. You guys straightened me out.
-Mark

--- In TableSmith@..., Bruce Gulke <brucegulke@...> wrote:

Vance is talking about the statement in the TS code. If the script says
this:

1,Is 17>=23? {If~17>=23?Yes/No}. Then, Is 17<=23? {If~17<=23?Yes/No}

The result is this:

Is 17>=23? No. Then, Is 17<=23? Yes

The second "If" as originally written says "If 17 is less than or equal to
23, then print 'no', otherwise print 'yes'." Since 17 is less than 23, it's
printing 'no' like it's being told.


On Thu, Mar 28, 2013 at 8:00 AM, Lemme <sylimaahn@...> wrote:

**


Unfortunately, the second statement is the output from TS from running the
first statement.

--- In TableSmith@..., "Vance" <clubvance@> wrote:

The only error I can see is in the second statement.
{If~17<=23?No/Yes}
should be
{If~17<=23?Yes/No}

Vance


----- Original Message -----
From: "Lemme" <sylimaahn@>


Hello,
The table I have been working on has a strange error. This is the
formula
and the output.
1,Is 17>=23? {If~17>=23?Yes/No}. Then, Is 17<=23? {If~17<=23?No/Yes}

Is 17>=23? No. Then, Is 17<=23? No

If I swap the <> I get the result I want, but the logic is wrong.
Other <>
statements work fine elsewhere in the same table. Am I crazy, SOL, or
other?
-Mark



[Non-text portions of this message have been removed]

1 - 5 of 5