IF statement help (has a range)

Okay, what I'm trying to do is to determine whether something is in the 'Hourly' range or 'Salary' range (or neither). The formula I have is:
=IF(H4=A2:A61,"Hourly",IF(H4=D2:D61,"Salary","Neither"))

Where am I going wrong here?

You can not use a range like that with an IF statement.

Try this instead:

=IF(COUNTIF(A2:A61,H4),"Hourly",IF(COUNTIF(D2:D61,H4),"Salary","Neither"))

That totally works - thanks.

You're welcome. Happy to help.

Thanks for the rep!