View Full Version : Excel help
Rikest
Sep 28, 2016, 12:45 PM
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")))
Curlyben
Sep 28, 2016, 01:07 PM
Is it all within the "job" sheet
Rikest
Sep 28, 2016, 01:18 PM
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.
joypulv
Sep 28, 2016, 01:49 PM
I see nothing wrong with it. Tell us what you are seeing that's wrong.
ScottGem
Sep 28, 2016, 02:56 PM
=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.
Rikest
Sep 29, 2016, 06:20 AM
I can get all parts to work except the AND part.
Rikest
Sep 29, 2016, 06:42 AM
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.
ScottGem
Sep 29, 2016, 08:24 AM
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.
Rikest
Sep 29, 2016, 11:48 AM
That worked! Thank you so much... you're an angel!