• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel - Multiple If Conditions

dsubash

New Member
Dear All,

I need an excel formula with multiple if conditions and criteria to display a specific term.

Have attached a sample sheet for reference.

I need the Status Colum and Remarks Column to be filled based on the conditions given in the sheet. Tried multiple "if conditions", but combining all is a task.

Can someone help me out with a formula to address this. I need this for a teaching session.

I am not used to VB Scripts. Maybe a VB Code will also be helpful.

Thanks in Advance
Subash D
 

Attachments

  • Sugar HbA1c Report.xlsx
    11.7 KB · Views: 5
G17:
Code:
=IF(AND(D17>C17,C17>=$D$6,C17<=$E$6,D17>=$D$7,D17<=$E$7,E17>=20%,F17<=7),"OK","ReDo")
H17:
Code:
=VLOOKUP(F17,{0,"Out of range";4.5,"Non Diabetic (Good Control)";6.5000001,"Non Diabetic (Fair Control)";7.000001,"Diabetic (Bad Control)";10.1,"Diabetic (Poor Control)"},2)
Copy down
 
Back
Top