Hi Guys, 

Sorry, me again with another question. 

I want to have a calculation which produces the results of a test,  in effect there are 4 tests being conducted at once, which would be as follows:

Number > Limit + Test said "Go" = Correct

Number > Limit + Test said "Don't Go" = Wrong 

Number < Limit + Test said "Go" = Wrong

Number < Limit + Test said "Don't go" = Correct 

Not being very good at Filemaker, I don't know how to do this - so what would be the best way? I guess this is too detailed for an IF statement? 

Thanks!

Neil

 

 

This is not a question about Filemaker, but about logic. You have two propositions that can be either true or false, and a result that can be also true ("Correct") or false ("Wrong"). A truth table is a convenient tool for solving such problem: in your example, it could look like this:

Number < Limit	Test = "Go"	"Correct"
True	True	False
True	False	True
False	True	True
False	False	False

Now you just need to lookup the logical operator that matches the results column, and write your formula as =

If ( Number < Limit xor Test = "Go" ; "Correct" ; "Wrong" )

Note that Number < Limit and Number > Limit are not collectively exhaustive; you need to extend one of them to include the case of Number = Limit.

--
BTW, it would be convenient to make both Test and the result of this calculation Boolean - i.e. a number that can be either 1 (True) or 0 (False). In such case, the formula would be simply =

Number < Limit xor Test 

and you could format the field to display a true result as "Correct" and a false one as "Wrong".

 

Edited November 30, 20196 yr by comment

Thank you, that seems to work. 

The only issue I am having, is that some of this forms a calculation. 

So, for example, I have -7  -  -10 and it's giving me a positive number, and huge percentage increase!

How do I fix this? 

I am afraid I don't follow the plot. The only thing I can say is that -7 - - 10 is a positive number (+3). But I don't see what this has to do with your original question.