-If A1="X" and if any of (D1,E1, or F1)="Y" then Display C2?
How would I right this formula in Excel 2010? I'm trying to track how many hours each staff is with a client. So if my client is "X" and anyone of up to three staff is "Y" then display the amount of hours in C2.
Category
没有评论:
发表评论