Solved! Go to Solution.
@sienna28
Brilliant picture. The logic should look like this
If(
Value(Blood1.Text) < 120 And Value(Blood2.Text) < 80,
Green,
(Value(Blood1.Text) >= 120 Value(Blood1.Text) <= 129) And Value(Blood2.Text) < 80,
Yellow,
(Value(Blood1.Text) >= 130 Value(Blood1.Text) <= 139) And (Value(Blood2.Text) >= 80 Value(Blood2.Text) <= 89),
Orange,
Value(Blood1.Text) >=140 Or Value(Blood2.Text) >= 90,
RedOrange,
Value(Blood1.Text) > 180 Or Value(Blood2.Text) > 120,
Red
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Looks good
Thanks for that.
I am finding if I put values in for
181 and 122 then option 4 (Hypertension stage 2) is firing.
I was expecting option 5 (Hypertensive crisis) to display.
I think option 4 and 5 look similar
I know what the issue is... I needed to invert the order displayed on the chart when coding it, lol.
If(
Value(Blood1.Text) > 180 Or Value(Blood2.Text) > 120,
Red,
Value(Blood1.Text) >=140 Or Value(Blood2.Text) >= 90,
RedOrange,
(Value(Blood1.Text) >= 130 Value(Blood1.Text) <= 139) And (Value(Blood2.Text) >= 80 Value(Blood2.Text) <= 89),
Orange,
(Value(Blood1.Text) >= 120 Value(Blood1.Text) <= 129) And Value(Blood2.Text) < 80,
Yellow,
Value(Blood1.Text) < 120 And Value(Blood2.Text) < 80,
Green
)
Excellent - Works well
Many thanks
User | Count |
---|---|
261 | |
115 | |
97 | |
48 | |
41 |