IF Function, Excel - How do I set a value to True if column G2:G41 is set to "Pass"?

I'm seeing a lot of information for the IF function but nothing advising how I can set a value to true / false if selected cells in the same column all equal the same value.

I'm trying to set a cell (J2) to say 'Completed' if cells G2:G41 ALL have a value of "Pass", and 'Bugs' if any of those cells have "Fail" in them. So the formula I've got at the moment is:

=IF(G2:G41="Pass", "Completed", "Bugs")

But it keeps saying 'Completed' when cell G41 is set as "Fail".

Apologies if this is explained elsewhere! If there's a link anyone can provide if it is, I'd really appreciate it.

Thanks.