Feb 21 2022 01:29 PM
I need to compute costs in forehgn money using exchange rate in table. How do I avoid having to retype exchange rate for each cell with a formula? (what key do I use?)
Feb 21 2022 01:52 PM
@dw-hansen Take a look at the range name function. You can name a cell (e.g. the USD - GBP exchange rate) as USGBP and then refer to USGBP in your formulas. See more here Define and use names in formulas (microsoft.com)
Feb 28 2022 09:30 AM
Feb 28 2022 11:21 AM
Did you mean selecting a cell or range reference in a formula, then pressing F4 to make the reference absolute?
Feb 28 2022 01:57 PM
Feb 28 2022 02:26 PM
Using the $ is useful to lock down to a cell for copying formulas e.g a formula referencing $A1 will repeat to A1,A2,A3 etc when dragged down, but hold to A1 when dragged across. The inverse is true if you use A$1. To lock in Both directions you would use $A$1. As mentioned above using the F4 key in the formula can do this.
Named cells/ranges are much more useful when referring to cells on a different worksheet. i.e. you may have all of your conversion rates on one worksheet, and your formulas and data on another. Named ranges are also great when using Vlookup etc, as the ensure accuracy is maintained.
Feb 28 2022 03:07 PM
SolutionFeb 28 2022 03:07 PM
Solution