mardi 25 février 2020

IF AND OR Statment with 3 Variables and Overriding Values

Thanks in advance for answering this question. I would like to display a value based on Conditions.

Please see the link for Actual Values I am working with.

Condition 1: Display "Low" when: Blood <10, Biopsy Score <=6, Tumour Score <=7.

Condition 2: Display "Medium" when: Blood 10-20, Biospy Score =7, Tumour Score =8-9.

Condition 3: Display "High" when: Blood >=20, Biopsy Score >=8, Tumour Score >=10

The problem I am having is that you can have a Blood from result from condition 1, biopsy score from condition 2, and tumour score from condition 3. The condition 3 would trump/override all other conditions as its the highest Risk. The highest value from any condition should be shown. Someone could have the lowest blood and tumour score, but a biopsy score of 7 which would class them as MEDIUM. Data Table

I have tried the following formula; Formula

Where T3 is blood, U3 is Biopsy, V is tumour size

As you can see in the picture, I also have a blank cell as its not calculating properly.

Aucun commentaire:

Enregistrer un commentaire