Export result in Excel 2019

[Poloniumra]

Hi
I have this excel question, if one of the value from F cell ( from F2 to F20) have "FAIL" value, then export the result the result to G is FAIL, if not, export the result to PASS
What formular should I use in this?
I am using Excel 2019
Capture.PNG
Thanks you

[Sam Capricci]

Please update your profile for location excel version. These make a difference as to which formulas and delimiters can be used in formulas.
Second, please update your post with more information so we know what you are really asking.
Third, you marked the post as solved, is it? If not please remove that designation.
Fourth, your post title is in violation of forum rule #1, please update the title to something more appropriate to what your problem is, think in terms of search, based on your problem what search term/s would you use?
thanks.

[Poloniumra]

Hi, i have fix it
Thank you for noitce me

[Sam Capricci]

You didn't update your location so I don't know if you need a semicolon or comma as a separator but for now, I am not totally sure I understand what you want but this is an attempt...
=IF(COUNTIF(F2:F20,"FAIL")>0,"FAIL","PASS")