not equal to

[jonespandrew]

Hi There

I am trying to write the following formula can anyone help

=IF([Work Order Type]<>"PM",or "PM Remedial","Reactive","Planned")

In english it reads If work order type is not equal to PM or PM Remedial display reactive else display planned

[AlKey]

Try this

=IF(OR([Work Order Type]<>"PM",[Work Order Type]<>"PM Remedial"),"Reactive","Planned")

[oeldere]

=if(or("work order type"="PM",work order type"="PM Remedial"),"Reactive","Planned")