Craig has attended:
Excel Intermediate course
3d formuals
how can i update the value of the dollar(USD) to the pound (GBP)in a single seperate cell? can this be done automaticly via a saved link?
RE: 3d formuals
Hello Craig
Thank you for your question and welcome to the forum.
How often would you need to update the value; and where would this information come from?
If the information you are getting provides a conversion rate, which is situated in one cell, then you would be able to do a calculation using the conversion rate and the dollar value so that when the rate updates the GBP value updates too.
Kind regards
Amanda