Log In
Register
Home
April 25, 2022
Offline
Hi,
May I ask what IF formula I should have on this.
In the Team column the result will be like this:
Sales Team will appear if Proposal Manager is Cheryl, Dennis or Ernesto regardless of referral
GS Team will appear if Proposal Manager is not the 3 above and Referral column is not FS referral
FS Team will appear if Proposal Manager is not the 3 above and the Referral should be FS referral
I manually updated the results for now but appreciate if you can show me the IF string for this.
I have attached the excel that has the below info as well. Appreciate your help. Thanks.
| Proposal Manager | Referral | Team | |
| Cheryl | Direct | Sales Team | |
| Cheryl | Direct | Sales Team | |
| Dennis | Direct | Sales Team | |
| Ernesto | Direct | Sales Team | |
| Dennis | Direct | Sales Team | |
| Cheryl | Direct | Sales Team | |
| Ana | FS Referral | FS Team | |
| Dennis | Direct | Sales Team | |
| Angelo | FS Referral | FS Team | |
| Ernesto | Direct | Sales Team | |
| Angelo | FS Referral | FS Team | |
| Erica | GS Team | GS Team | |
| Christy | GS Team | GS Team | |
| Ana | FS Referral | FS Team |
See Answer
October 5, 2010
Offline
Hi Emmanuel,
You're file did not upload but I could work it out from your description.
This is the formula you need
=IF(OR(B3="Cheryl",B3="Dennis",B3="Ernesto"),"Sales Team",IF(C3="FS Referral","FS Team","GS Team"))
Check my attached file to see it.
Regards
Phil
Answers Post
1 Guest(s)
