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