Found this content helpful? Log in or sign up to leave a like!

Are there Boolean Helper Functions?

Jump to solution
BobbyWinters
Community Member

I am teaching a course called Mathematics for Programming.  As a part of that, I am teaching about logic and truth tables.  I would like to give quizzes that included formula questions about boolean functions.  The only function I've been able to find that is even close to a boolean function is IF(_,_,_).  Are they there and am I just missing them?  Is it possible to hack them?  It is possible to import them?b

Labels (2)
1 Solution
Gabriel33
Community Participant

For a list of the functions available, see Canvas Formula Quiz Question Helper Functions - Instructure Community - 387062

If you treat 1 as TRUE and 0 as FALSE (which you probably have to anyway in formula questions), you can indeed "hack" them, such as doing, for example

  • NOT X as 1-X
  • X AND Y as X*Y
  • X OR Y as max(X,Y)

If you want to expand TRUE to being anything different from zero, that can make things a bit uglier, first testing to see if it is 0, and if not dividing by itself for each statement, something like if(X=0,0,X/X).

Do you have any particular boolean function in mind?

View solution in original post