# If with multiple arguments

1. ## If with multiple arguments

Hi,

I am looking for help on an IF statement where I would like the specific customer number to determine which sales team pot it goes into -

Column C has a formula that determines what team pot it goes into but I need to adjust current formula to reflect -

Code in column G starts with "CP" then goes to "INTRA"
Code in column G starts with "CS" then goes to "INTER"
If column M shows as "FHA" after the first 2 arguments then populate column C as "FHA"
IF column M is not ANY of the values as above then it should be classed as "TRADE"

Original formula assigned companies to 3 separate pots -

Any help would be appreciated.

2. ## Re: If with multiple arguments

Ostensibly this:

However, I don't think that's what you mean.

Can you tell us ONE cell in column C that should be returned as FHA and why?

Try:

4. ## Re: If with multiple arguments

Hi Ali,

In the attached spreadsheet there is only one row where it is classed as FHA (Row 8). To be honest I am 2 days into a new role and have had very little explanation as to the data source or why the records seem so confused. I have literally just been told to amend an existing formula to meet the rules listed above. I have a further meeting later re this and hope to get further clarification but as of just now I am working with basic info. So any help at all is very much appreciated.

Thanks

5. ## Re: If with multiple arguments

Hi Glenn,

This seems to be working a treat. I will leave this post open until I can confirm for definite however and close it later once I know.

I really appreciate the help!

Thanks

6. ## Re: If with multiple arguments

On the assumption that it's OK... you're welcome. If not, shout.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

7. ## Re: If with multiple arguments

You haven't fully answered my question, actually.

So WHY is row 8 FHA and NOT INTER? In what circumstances should FHA trump INTER, or any other category?

8. ## Re: If with multiple arguments

Ignore my previous post - it seems that Glenn worked it out.

9. ## Re: If with multiple arguments

Because it meets both the "either CP or CS" criterion (G) and the "FHA" criterion (M).

10. ## Re: If with multiple arguments

Yes, you worked it out - I thought that's what he was getting at, but it wasn't 100% clear (to me).

11. ## Re: If with multiple arguments

Nor to me, tbh. I had the IFs the wrong way round at first and noticed that there were no FHAs in the answers. So, I guessed that one HAD to be there.

12. ## Re: If with multiple arguments

@AliGW @Glenn thanks both of you for answering so quickly. I will see if this is what my new boss was meaning and then close this post asap, but if not then I shall come back and clarify further.

13. ## Re: If with multiple arguments

That's kind of you. Yes, leave the thread open until you are sure, but I think that's what you need.

There are currently 1 users browsing this thread. (0 members and 1 guests)