I have been trying to automate the Myers Briggs Type Indicator and can read
the results based on numerical input. The results, individual cells, look
like this example:

I Total = 25, E Total = 15
N Total = 25,S Total = 15
T Total = 10, F Total = 30
P Total = 30, J Total = 10

This means that the person has a stye type of: INTP

How can I convert the raw numerical data to display the alpha combination.
There are 16 possible permutations as follows (Depedent on the high scores).

ESTP, ESTJ, ESFP, ESFJ, ENFP, ENFJ, ENTP, ENTJ,
ISTJ, ISTP, ISFJ, ISFP, INFJ, INFP, INTJ, INTP

=IF(A2B2,"I","E")&(IF(A3B3,"N","S"))&....

T Total = 10, F Total = 30
INTP?

What happens if scores are equal?


"Jetlag" wrote in message
...
I have been trying to automate the Myers Briggs Type Indicator and can read
the results based on numerical input. The results, individual cells, look
like this example:

I Total = 25, E Total = 15
N Total = 25,S Total = 15
T Total = 10, F Total = 30
P Total = 30, J Total = 10

This means that the person has a stye type of: INTP

How can I convert the raw numerical data to display the alpha combination.
There are 16 possible permutations as follows (Depedent on the high
scores).

ESTP, ESTJ, ESFP, ESFJ, ENFP, ENFJ, ENTP, ENTJ,
ISTJ, ISTP, ISFJ, ISFP, INFJ, INFP, INTJ, INTP

David,

Thanks mate, I'll try it out today.

If the scores are equal. It means that there is no preference and that we
could use a different symbol to note this fact.er equal

"David Cox" wrote:

=IF(A2B2,"I","E")&(IF(A3B3,"N","S"))&....

T Total = 10, F Total = 30
INTP?

What happens if scores are equal?


"Jetlag" wrote in message
...
I have been trying to automate the Myers Briggs Type Indicator and can read
the results based on numerical input. The results, individual cells, look
like this example:

I Total = 25, E Total = 15
N Total = 25,S Total = 15
T Total = 10, F Total = 30
P Total = 30, J Total = 10

This means that the person has a stye type of: INTP

How can I convert the raw numerical data to display the alpha combination.
There are 16 possible permutations as follows (Depedent on the high
scores).

ESTP, ESTJ, ESFP, ESFJ, ENFP, ENFJ, ENTP, ENTJ,
ISTJ, ISTP, ISFJ, ISFP, INFJ, INFP, INTJ, INTP