Entering a formula in a cell based on the selections in two other drop down lists

Hi I have 2 columns with drop down boxes. Column A has many options that I can select in a drop down list. Examples are I buy foreign currency, I sell foreign currency, I buy C$, I sell C$, I buy GBP, I sell GBP. Column B has a list of currencies (C$, US$, GBP for example). Column C is where I input a number (say 100,000), and Column D is where I input a conversion rate (say 1.50). I then have 4 columns (E to H), one for each of 4 currencies, one of which will populate using a formula based on the selections in A and B. So for example, if Column A selected I buy C$ and Column B selected US$, then Column E (which has my US$ values) would show the result of a formula multiplying 100,000 times 1.50. But I then want the other 3 columns to remain empty since the selections in A and B exclude them. Is there a simple way to do something like this? Thanks for any help!

Did it work? I just tried to do it

thanks, that doesnt really work since it ignores the selection in column B>

For example if B2 selects "Desk Buys Foreign vs CAD" and C2 selects "USD" then F2 would return "=D2", G2 and H2 would be blank, and I2 would return "=D2*E2"

But if C2 selected "GBP" instead then F2 and H2 would be blank, G2 would return "=D2", and I2 would return "=D2*E2"

Does that make sense? I am trying to avoid doing a very long nested ifstatement (my actual sheet has many more options in each drop down list)

Thanks! I'm trying to figure out what you did - I am not familiar with these formulas! I will let you know when I get a better understanding of the because I will have to expand it and make some changes (right now the formula isn't differentiating between positive and negative values, and also isnt differentiating between when the formula requires a multiplication or division. But I am really hoping that this will help incorporate these requirements, Thanks a lot!

Just as an example

-->if B2 is Desk Buys Foreign vs CAD and C2 is USD, F2 formula should be "=D2" and I2 formula should be "=-(D2)*E2"

-->if B2 is Desk Sells Foreign vs CAD and C2 is USD, F2 formula should be "=-(D2)" and I2 formula should be "=D2*E2"

--> if B2 is Desk Buys Foreign vs USD and C2 is CAD, F2 formula should be "=-(D2)/E2" and I2 formula should be "=D2"

--> if B2 is Desk Sells Foreign vs USD and C2 is CAD, F2 formula should be "=D2/E2" and I2 formula should be "=-(D2)"


Does that make sense?

Thanks - got part of it right (the positive or negative amount), but not the direction (whether to multiply or divide by - thats the part that i can never get past)

Thanks for trying!

I think I solved it myself thanks!