Ask Experts Questions for FREE Help !
Ask
    Rikest's Avatar
    Rikest Posts: 5, Reputation: 1
    New Member
    		  
    #1

    Sep 28, 2016, 12:45 PM
    Excel help
    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's Avatar
    Curlyben Posts: 18,514, Reputation: 1860
    BossMan
    		  
    #2

    Sep 28, 2016, 01:07 PM
    Is it all within the "job" sheet
    Rikest's Avatar
    Rikest Posts: 5, Reputation: 1
    New Member
    		  
    #3

    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's Avatar
    joypulv Posts: 21,591, Reputation: 2941
    current pert
    		  
    #4

    Sep 28, 2016, 01:49 PM
    I see nothing wrong with it. Tell us what you are seeing that's wrong.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #5

    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's Avatar
    Rikest Posts: 5, Reputation: 1
    New Member
    		  
    #6

    Sep 29, 2016, 06:20 AM
    I can get all parts to work except the AND part.
    Rikest's Avatar
    Rikest Posts: 5, Reputation: 1
    New Member
    		  
    #7

    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's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #8

    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's Avatar
    Rikest Posts: 5, Reputation: 1
    New Member
    		  
    #9

    Sep 29, 2016, 11:48 AM
    That worked! Thank you so much... you're an angel!
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect one excel sheet to other excel sheet [ 28 Answers ]

How to connect one excel sheet to other excel sheet.

How to link multiple excel sheets to one main source excel sheet [ 7 Answers ]

I have a master price list and multiple ( individule ) sheets for customers.. I would like to , when input data in the price list to link and update to all other sheets... ( I do not want to have a source sheet with tabs) Thanks

Excel [ 2 Answers ]

I want to set up a way for me to insert some information into a table on excel and if a certan word is input then it will copy that line of info to a another sheet within the spreadsheet have you got any ideas the help would be much appreciated

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Excel help [ 1 Answers ]

I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then...

View more questions Search