Need function help for work

[lapiram]

I need a function for an excel file at work where if value of column E (from E4 to Finfinity) is equal to 002,003 or 019 cell in column F (F4 to Finfinity) reads as MAJOR while if it reads another value it reads as critical
Can't find anything on the internet so I would appreciate any help I can get.

 

[Special-K99]

in F4
if F4 is text
=IF(OR(F4="002",F4="003",F4="019"),"MAJOR","CRITICAL")
or if F4 is a number
=IF(OR(F4=2,F4=3,F4=19),"MAJOR","CRITICAL")