
THE WEIGHT ICON FORMULA:
=IFS(
OR(ISBLANK(B2),ISBLANK(B3)),””,
B2>B3,”π’”,
B2<B3,”π΄”,
TRUE,”β”
)
THE RESTING BLOOD SUGAR LEVEL ICON FORMULA:
=IFS(ISBLANK(D3),””,D3<70,”π΄”, D3<=99,”π’”,D3<=125,”π‘”, TRUE,”π΄”)
THE BLOOD PRESSURE LEVEL ICON FORMULA:
=IFS(OR(H2=””,I2=””),””,OR(H2>=180,I2>=120),”π¨”,OR(H2>=140,I2>=90),”π΄”,OR(H2>=130,I2>=80),”π ”,H2>=120,”π‘”,TRUE,”π’”)
THE ICONS:
π¨π΄π π‘π’β¬οΈβ¬οΈβ