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 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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
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.