Search:

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

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...

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

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.

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")))