Can anybody give me an example of when I would use the TRUE function and the FALSE function as Microsoft help is a little light on the subject!!
MasterMind Game and a Process of Elimination
I have a basic Process of Elimination procedure on paper that solves the MasterMind challenge , using 6 colors and the standard 8 rows of testing,
I would like to use Excel logical functions to create a basic MasterMind solver game.
I'm hoping to find someone who would enjoy the challenge of working on this problem and begin a dialogue seeking a solution.
For someone interested but not knowing how the game is played, there are a number of internet sites devoted to the MasterMind game on the internet.
The game has 2 players. The first player (the codemaker) creates a code by choosing four random colors out of a possible 6 and placing them in a particular position with 4 possible slots (holes). This code is hidden from view.
The other player makes a guess by placing colored pegs in the first row. Then the codemaker responds by using black pegs for correct color and correct position or a white peg if the color is right but in the wrong position and no peg if neither color or position is correct.
The problem is to transfer the paper structure into a series of Excel logical functions. I understand that a program could incorporate the whole game more efficiently, but it would be intellectually satisfying to discover how the problem can be solved with logical functions.
I use letter references for each color: B for blue, G for Green, P for Purple, Y for Yellow, O for Orange and R for Red.
What is needed:
The Codemakers original placement
1. Set a code, say to place B in position 1, R in position 2, Yellow in position 3 and Purple in position 4?
A follow up to this would be for Excel to randomly generate a code.
2. Next would be the players selection of a color for each of the 4 available slots (holes for pegs).
The idea of having an Excel cell with one of the unique colors available for the player to choose/select. Would need a means to cancel a selection and choosing another color.
3. How can logical functions evaluate the color and position of a guess as it relates to the original code?
If a color is in the correct slot, the codemaker responds with a black peg for that position. A white peg signals the correct color but wrong position. A blank indicates that neither position nor color are correct.
4. This next phase would consist of helping the player best interpret the responses of black, white and no pegs.
Regards,
Hayden Knox
Hi,
I'm having some difficulty with excel 2007. My problem is that I have a list of dates (e.g., 5/12/2010 - 7/28/2010) in a pivot table and I want to create a logical function to filter these dates i.e., I want the function to filter the list to display dates that are 3, 7, 14, and 30 days prior to the current date.
Any help would be appreciated.
Can anyone please tell me how (or what) logical formulas to write in Excel2000 for a yes/no decision based on the following (attached file) in a different pricing worksheet?
The criteria are to set a pricing sheet where user can select the car they would like to purchase and their desired option. Eg. in Y? column, put a Y(yes) for chassis type and put Y in the relevant options sections, will produce (base car price + gadgets + safety + luxury options total price in another area of worksheet).
Please help
What I'd like to do is create a set of conditional statements. If the cell
a1="cat", then the number in a2*.25. If the cell a1="dog", then the number
in a2*.75. A1 will always say dog or cat. The then part of the statement
changes based on the text. Any suggestions on how to accomplish this?
Thanks.
Hi, I'm fairly new to Excel and am struggeling with a formula that I think should be reasonably simple.
Based on some data I have two columns which each calculate either "TRUE" or "FALSE" based on the rules I have applied.
I now want to be able to have a third column that will display "CORRECT" if the first two columns display "TRUE", display "INCORRECT" if both display "FALSE" or "FUTHER EVALUATION" if the columns have one of each "TRUE" and "FALSE".
If it helps the first rule is based on an "IF" formula and the second on an "AND" forumla.
Any help with developing this formula would be greatly appreciated.
Thanks in advance.
in excel i want to increase the figures by 10, 20, & 30 percent respectively
for the following ranges: below 10000 = 10%, between 10000 & 40000 = 20%,
above 40000 = 30%. How do I create this logic in the if statement. I shall
aprreicate your help
can Excel logical functions recognize cell color shading? For example, a
cell formula be created to add cells in a column that are shaded green and
ignore cells shaded blue?
Hi,
I need a function that says this: if the text in the cell contains the character ";", return the number "2" and if it doesn't contain ";", return "1".
Probably an easy one!
Thanks.
Hi Everyone,
I am trying to write a macro that will use an IF AND statement to run another macro. Basically, if contents in two separate drop down boxes are selected, I would like a another macro to run. Here is what I started with:
Sub TEST()
If C52 = 1 And C66 = 1 Then
TRIAL Macro
End If
End Sub
This is my first time working with macros, and I would appreciate any help you can offer.
Thank you!
