I want to complete this style of logic in Excel but am not sure how. \\
values in a table B2:M2, they will contain either 3 types of values M100, H100 or NA. After M there may be any different number result between 0 and 100. So (M80, M82, M64 are valid).
H stands for Home and M stands for...