Looking for a specific kind of software

August 13, 2010 at 19:23:02
Specs: Windows XP, 4096
I made a simple picture to help illustrate the interface and usage of what I'm looking for: click

This program would allow me to simply click to highlight a specific value for each column and have it give the result that I've assigned based on the selected combination of values. It wouldn't need to make any calculations, just give a true/false result.

The requirements are that A) I can choose the amount of specific values as well as how many each have and B) Automated entering of the results, e.g. if I know that 'Red' should always result as true, or if the combination of '3' and 'Out' always should result as false, then I can speed up the process of assigning the results faster than if I had to manually assign the result of each possible combination (in this case 500 combinations).

Did I make myself clear? =)


See More: Looking for a specific kind of software

Report •


#1
August 13, 2010 at 20:03:29
Hi,

Apart from "No",
I have a couple of questions:
You say:

It wouldn't need to make any calculations, just give a true/false result.

How can Excel return a result without performing any calculations. If different cells have varying values, then some form of logic is required.

How do you propose to select the cells in the four columns shown in your image (call them A to D for example)

If you used Validation drop-down lists in four cell, say A1 to D1
and A1 could only be:
A, B, C, D or E
and B1 could only be:
1, 2. 3, 4 or 5
and so on, then:
the result in another cell can be based on the results in cells A1 to D1

Regards


Report •
Related Solutions


Ask Question