If statement to match two cells of information

This function only uses two cells, E2 & D2. I need an if function that asks is cell E2 greater than or equal to 500000 and if cell D2 is BR then it is platinum, if less than 500,000 but greater than or equal to 250,000 and is BR then it is Diamond, if less than 250,000 but greater than or equal to 100,000 and is BR then it is Gold, if less than 100000 but greater than or equal 50000 and BR then it is Silver, If cell E2 is greater than or equal to 250000 and cell D2 is CD then Platinum, If less than 250,000 and greater than or equal to 100,000 and it is CD then it is Diamond, If less than 100,000 but greater than or equal to 50,000 and CD then it is Gold, If less 50,000 but greater than or equal to 15,000 and CD then it is Silver, If greater than or equal to 150,000 and DR then it is Platinum, If less 150,000 but greater than or equal to 50,000 and DR then it is Diamond, If less than 50,000 but greater than or equal to 15,000 and DR then it is Gold, If less than 15,000 but greater than or equal to 7500 and DR then it is Silver, If greater than or equal to 100,000 and ENT then it is Platinum, If less than 100,000 but greater than or equal 25,000 and ENT then it is Diamond, If less than 25,000 but greater than or equal to 15,000 and ENT then it is Gold, If less than 15,000 but greater than or equal to 7500 and ENT then it is Silver. How would this function look?

Here is an attachment of what i am talking about, the status' are on the category status tab on the bottom. Those are the results I want receive from cell G2 by using cells E2 & D2 like explained in my first post.

Here is an attachment of what i am talking about, the status' are on the category status tab on the bottom. Those are the results I want receive from cell G2 by using cells E2 & D2 like explained in my first post.

Hey thanks, that looks good from what I can tell, I added HO to the Category Status page so it reads HO also, and it reads it. I attached a copy of it if you want to take a look at it. Also if possible, can you explain how you set the formula up or direct me somewhere where I will be able to find out.

Thanks.