What's wrong with this formula
=IF(C19=10.1,"Job 1",IF(C19>10.1<11.5,"Job 2",IF(C19>=11.5,"Job 3")))

Is it all within the "job" sheet

I have a pay rate column... I need to know if each employee is a rate 1, 2, or 3 based on the hourly rate.

I see nothing wrong with it. Tell us what you are seeing that's wrong.

=IF(C19=10.1,"Job 1",IF(C19>10.1 AND C19<11.5,"Job 2",IF(C19>=11.5,"Job 3","")))


2 things wrong, you need the AND on the second condition and you need a false result for the third condition.

I would also look and see if Excel has the Switch function.

I can get all parts to work except the AND part.

Here is the formula that I am using

=IF(C10=10.1,"Job 1","",IF(C10>10.1<11.5,"Job 2","",IF(C10>=11.5,"Job 3")))

The error that I am getting says that I have used too many arguments for this function.

this worked for me:

=IF(C10=10.1,"Job 1",IF((C10>10.1)*AND(C10<11.5),"Job 2",IF(C10>=11.5,"Job 3","")))

The syntax for an IF is If(condition,True result, false result). So by using IF(C10=10.1,")))

The syntax for an IF is If(condition,True result, false result). So by using IF(C10=10.1,","",IF(... You had 4 arguments. Then in the last IF you only had 2 arguments.

That worked! Thank you so much... you're an angel!