-

2011年8月3日星期三

If A1="X" and if any of (D1,E1, or F1)="Y" then Display C2?

-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

没有评论:

发表评论