Text if/then formula to use seperate formulas

amilcaranastasia Posts 2 Registration date Wednesday September 5, 2012 Status Member Last seen September 5, 2012 - Sep 5, 2012 at 12:18 PM
 amilcaranastasia - Sep 6, 2012 at 11:17 AM

I am trying to make a formula to determine how many days (minus weekends) it took to complet a project. The problem is that I have one employee Alan Bown (initials AB) who works Monday-Friday and a second employee Cristopher Duncan (initials are CD) who work Monday-Thursday. I know that the formula for "AB" would be:
and the formula for "CD" would be:

If the employee's initials are in cell A1, project start date is in cell B1 and project end date is in cell C1, I want to create a formula that says "if A1 = AB then use this formula, but if A1 = CD then use the other formula"

Is there a way to do this?


1 response

ExcelJosh Posts 12 Registration date Wednesday August 8, 2012 Status Contributor Last seen October 12, 2012
Sep 5, 2012 at 01:53 PM

Replace the "AS","BS","GS", "HG" with the initials of the employees.
Replace the $B$1, $B$2, $B$3, $B$4 with the formulas.

The IF formula is =IF(logic, [if true], [if false]), so I created a nested IF formula.

Let me know if this makes sense or if you have questions.

Good luck,
Sep 6, 2012 at 11:17 AM
Thank you Josh. That worked perfectly, you just made my life easier and my boss happier!