Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I am trying to build a currency converter into a spreadsheet. I have 2 cells with drop down menus (GBP, USD, EUR) and need a formula along the lines of IF B6=USD AND D6=GBP, D8 (my results cell) should equal B8 (the value to be converted) divided by P3 (a cell containing the conversion rate)
Solved by X. F. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/04/2018 - 09:59
Dear Student. I hope you're doing great today! :-)
User 05/04/2018 - 09:59
I am, you too! :)
Excelchat Expert 05/04/2018 - 10:00
Do you have data that we can work on?
User 05/04/2018 - 10:00
None yet!
Excelchat Expert 05/04/2018 - 10:01
Ok. Let's try to get you the format. :-)
Excelchat Expert 05/04/2018 - 10:01
Can you further describe the problem? Thank you.
Excelchat Expert 05/04/2018 - 10:01
You have 3 currencies
User 05/04/2018 - 10:01
Yes
User 05/04/2018 - 10:02
I need to be able to convert interchangeably
Excelchat Expert 05/04/2018 - 10:02
What you need is the automatic conversion according to currency.
Excelchat Expert 05/04/2018 - 10:02
Right?
User 05/04/2018 - 10:02
Yes
Excelchat Expert 05/04/2018 - 10:02
Ok. Got it, Will get back to you in a while.
Excelchat Expert 05/04/2018 - 10:02
Allow me to work in a separate sheet which you won't be able to view. The sheet you're seeing in the monitor is quite complicated to use. :-)
User 05/04/2018 - 10:03
Thanks :)
User 05/04/2018 - 10:03
It's only a simple tool so I don't have to pick up a calculator and do the same sums every 5 minutes but it would make my life 100,000,000000% easier :D
Excelchat Expert 05/04/2018 - 10:03
Sure. :-)
Excelchat Expert 05/04/2018 - 10:13
Excelchat Expert 05/04/2018 - 10:13
HI. Can you check the file.
User 05/04/2018 - 10:14
Sure!
Excelchat Expert 05/04/2018 - 10:15
The exchange rates are just samples.
Excelchat Expert 05/04/2018 - 10:16
You have the dropdown there. Plus the automatic computation accoring to the currency.
User 05/04/2018 - 10:16
That is amazing, thank you so much for your help :)
Excelchat Expert 05/04/2018 - 10:16
My pleasure. :-)
Excelchat Expert 05/04/2018 - 10:16
Excelchat Expert 05/04/2018 - 10:16
Have a beautiful day and God bless you!
User 05/04/2018 - 10:17
Just one quick question
Excelchat Expert 05/04/2018 - 10:17
Sure.
User 05/04/2018 - 10:17
The exchange rates I need to 4 decimal places but I can see the cells are custom format
User 05/04/2018 - 10:18
Can I just change that without it affecting the formula? :)
Excelchat Expert 05/04/2018 - 10:18
Excelchat Expert 05/04/2018 - 10:18
No that wont affect the formula at all.
User 05/04/2018 - 10:19
Lovely, thank you!¬
User 05/04/2018 - 10:19
Have a wonderful day!
User 05/04/2018 - 10:19
:)
Excelchat Expert 05/04/2018 - 10:19
Thank you. God bless. :-)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.