Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

d formuals

ResolvedVersion 2003

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

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.