Text if/then formula to use seperate formulas

Solved/Closed
Report
Posts
2
Registration date
Wednesday September 5, 2012
Status
Member
Last seen
September 5, 2012
-
 amilcaranastasia -
Hello,

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:
SUM(INT((WEEKDAY(B1-{2,3,4,5,6})+C1-B1)/7))
and the formula for "CD" would be:
SUM(INT((WEEKDAY(B1-{2,3,4,5})+C1-B1)/7))

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 reply

Posts
12
Registration date
Wednesday August 8, 2012
Status
Contributor
Last seen
October 12, 2012

=IF(A1="AS",$B$1,IF(A1="BS",$B$2,IF(A1="GS",$B$3,IF(A1="HG",$B$4))))

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,
Josh

Thank you Josh. That worked perfectly, you just made my life easier and my boss happier!