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 14 mins