hmm...
by William96
In reply to
Couple of thoughts
im sorry. i am still just a student, the code ? 
maybe this will help: 
The function is: =IF(
Excel Function issue.
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.
This conversation is currently closed to new comments.