Below I have a layered If statment. I was wondering how to make the following piece work to where it would say if Q4 does not equal AP$2 instead of equals. Can this be done?
IF(Q4=AP$2,"Reset-Fixed","Matured")
=IF($N4="ERROR","ERROR",IF($M4="fixed","Fixed",IF(Q4=AP$2,"Reset",IF(Q4=AP$2,"Reset-Fixed","Matured"))))
IF(Q4=AP$2,"Reset-Fixed","Matured")
=IF($N4="ERROR","ERROR",IF($M4="fixed","Fixed",IF(Q4=AP$2,"Reset",IF(Q4=AP$2,"Reset-Fixed","Matured"))))