Solved

Boolean Logic using VB functions

Posted on 2004-04-21
8
453 Views
Last Modified: 2012-06-27
I need to get visual basic to do boolean algebra so it can act like a combinational logic circuit.
I programmed it to give an output with a boolean equation but it has been returning decimal values. Why is this? This is the code I used :

Gout = ((NOT B) OR ((NOT A) AND (NOT D)) OR ((NOT A) AND (NOT C) AND (NOT F)) OR ((NOT A) AND (NOT C) AND (NOT E) AND (NOT H))

Please note also that the variables A,B,C,D,E,F,H all represent smaller formula's. These formula's use binary inputs from text boxes. The smaller formula's are all written before the Gout output in the program.
  Can you please help me with this its very urgent.
0
Comment
Question by:junebrady
8 Comments
 
LVL 5

Expert Comment

by:ennixo
Comment Utility
you must define variables' types


Dim A As Boolean, B As Boolean, C As Boolean, D As Boolean, E As Boolean, F As Boolean, H As Boolean, Gout As Boolean
0
 
LVL 6

Expert Comment

by:PhilAI
Comment Utility
Or use the CBool function to convert each variable to Boolean
0
 
LVL 19

Expert Comment

by:RanjeetRain
Comment Utility
>> Please note also that the variables A,B,C,D,E,F,H all represent smaller formula's

Your formulaes must return Boolean values. For testing purpose do this.

MsgBox A
MsgBox B
MsgBox C
MsgBox D
MsgBox E
MsgBox F
MsgBox G
MsgBox H

If any of them display any values other than a "True" or a "False", then you know where to check!
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 76

Expert Comment

by:David Lee
Comment Utility
I don't think you HAVE to define the variables types, although it certainly makes sense to do so.  Consider the online help text for the Boolean data type:

----

Boolean variables are stored as 16-bit (2-byte) numbers, but they can only be True or False. Boolean variables display as either True or False (when Print is used) or #TRUE# or #FALSE# (when Write # is used). Use thekeywords True and False to assign one of the two states to Boolean variables.

When other numeric types are converted to Boolean values, 0 becomes False and all other values become True. When Boolean values are converted to other data types, False becomes 0 and True becomes -1.

----

If the values coming back are 0 and/or -1, then you are getting the numeric representation of a True/False result.  If the values are something other than 0 and -1, then as the help text states "all other values become true".  Declaring the variables as type Boolean will make interpreting the results easier and will preclude a varibale from having a value other than true or false, but it's not absolutely essential so long as you understand the rules the system uses to determine true and false values in non-Boolean data.
0
 
LVL 6

Expert Comment

by:___XXX_X_XXX___
Comment Utility
I think that the author meant something different.

Suggestion:
These variables A,B,C,D,E,F,G and H are 8 bit numbers from 0 to 255.
So he want to make some bitwise operations like AND:
01110100
AND
00110010
________
00110000

This is "boolean algebra" for me.

junebrady: How many states (different values) your variables from A to H can have ? Is your A-H variables can contain only 0 and 1 (1 bit) or they can contain 8 bit values ?

"I programmed it to give an output with a boolean equation but it has been returning decimal values. Why is this" - Because these AND , NOT , OR operates over bits in bytes. So as above AND example, this is equivalent to
116  (Decimal)
AND
50    (Decimal)
______________

48   (Decimal)


For example try this:

MsgBox 116 And 50 ' Returns 48 as above
MsgBox 255 And 47 ' Returns 47
MsgBox 1 Or 2 ' Returns 3
MsgBox 1 Or 3 ' Returns 3
MsgBox 2 Or 3 ' Returns 3
MsgBox Not 255 ' Returns 0

You can "feel" boolean algebra logic in last 4 MsgBox examples.
Is that you need ?
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
Comment Utility
PAQed - no points refunded (of 125)

Netminder
Site Admin
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now