If Statement with Multiple Criteria

Hi there,

I am working on a sheet that requires an IF statement with three total criteria. I have attached the worksheet for easy reference. Here is what I need. In Cell B3 of the PTO calculator sheet, I currently have this If statement: =IF('Data Sheet (Formulas)'!C2>12,'Data Sheet (Formulas)'!C17,IF('Data Sheet (Formulas)'!B2='Data Sheet (Formulas)'!L2,'Data Sheet (Formulas)'!C18,'Data Sheet (Formulas)'!C16)). The problem is that is does not work for all criteria.

On the Data Sheet the cells highlighted in Red text are the values that need to be inputted into the cell based on the criteria match. Here are my three criteria all based on the Data Sheet.

1.) If Cell B2 = Cell L2 then return value in cell C18
2.) If C2 is > 12 then return value in cell C17
3.) If neither of those conditions are met, then return the value of C16.

Please let me know if you have any questions. Thank you in advance

Maybe:

Please Login or Register  to view this content.

Thank you, the first one worked great and I just did =value on the other sheet to pull in the answer. John, yours gave me the same error I was getting.