Hi,
I want a text to appear in a cell based on the value in the cell before . This is my formula:
=IF(($AR6=1),"General Communication Periodic Monitoring",IF(AND($AR6>1,$AR6<=2),"General Communication Periodic Monitoring Safety Procedure Training",IF(AND($AR6>2,$AR6<=3),"Specific Hazard Communication Work Practice Control Periodic Monitoring",IF(AND($AR6>3,$AR6<=4)," Medical Surveillance Work Practice Control Exposure Control Plan Periodic Monitoring",IF(AND($AR6>4,$AR6<=5),"Engineering Control Respirator Medical Surveillance Work Practice Control Exposure Control Plan Periodic Monitoring ")))))
I don't know what is the mistake. The text doesn't appear. Can you help me, please?
I want a text to appear in a cell based on the value in the cell before . This is my formula:
=IF(($AR6=1),"General Communication Periodic Monitoring",IF(AND($AR6>1,$AR6<=2),"General Communication Periodic Monitoring Safety Procedure Training",IF(AND($AR6>2,$AR6<=3),"Specific Hazard Communication Work Practice Control Periodic Monitoring",IF(AND($AR6>3,$AR6<=4)," Medical Surveillance Work Practice Control Exposure Control Plan Periodic Monitoring",IF(AND($AR6>4,$AR6<=5),"Engineering Control Respirator Medical Surveillance Work Practice Control Exposure Control Plan Periodic Monitoring ")))))
I don't know what is the mistake. The text doesn't appear. Can you help me, please?