I am a student and I am working with Excel at the moment.
Now I have a small problem with the project i am working on in my ICT Class.
I am to create a currency converter with Excel.
Now i have created a graph of Euro – Us Dollars – Pounds…. I will not go into detail. I got as far as using the IF Function as this [image-link]: http://i876.photobucket.com/albums/ab326/william961/Capture1-1.png
Now I would like to know how can I add 2 more possibilities to the logical_test section in the function. Right now I have got USD($) between the ” ” But actually I will need 3 or more currencies…. Why ? – because I have created a Drop down list in the cell of D7 like above. So if i choose a different currency in that drop down list such as EUR(???) for example, how am I able to add that to my IF function ? ….
Because the logical_test will not have the other currencies that means the value_if_false will kick in… but i dont want that.
Maybe i have to add another series of () to make it into some kind of double IF function ? I have no idea. Thats why I Need you guys to tell me what I have to change in the Function.
Thank you 🙂
Regards William.
