Greeting,
I am preparing a machine monitoring excel sheet. Values for the parameters are populated thru phd uniformance.
For example I have listed four tag nos. for vibrations.
Column I has the value populated from PHD
In Column M has the return value based on the formula (shown in the attached picture)
Now I want to write a formula to check the four outputs and return with following.
1) "NORMAL" is all four cell have "Normal"
2) "ALERT" is one of the cell has "Alert" and rest are "Normal"
3) "DANGER" if one of the cell has "Danger" and rest are "Normal" OR "Alert"
I've tried this formula but is not working. Pl help
=IF(OR(M5="Danger", M6="Danger",M7="Danger",M8="Danger")="Danger", "DANGER", IF(OR(M5="Alert", M6="Alert",M7="Alert",M8="Alert")="Alert","ALERT","NORMAL"))
Bookmarks