Help with formulas in Excel

Ladywriter1968

I have read that to work out exchange rates in USA the formula is something like this: $A$1*A9 etc,. and so fourth, the use of the dollar sign for which ever cells or rows they are in then multiplied,

But my question is, say its for other countries like Lire or Rubis or somewhere else, what is the formula to work out other currency exchange rates?

tronator

Ladywriter1968 wrote: »

I have read that to work out exchange rates in USA the formula is something like this: $A$1*A9 etc,. and so fourth, the use of the dollar sign for which ever cells or rows they are in then multiplied,

But my question is, say its for other countries like Lire or Rubis or somewhere else, what is the formula to work out other currency exchange rates?

It's exactly the same formula. The Dollar sign has nothing to do with the currency symbol. The currency you define with the format of the cell. $A$1 means that if you copy the formula to a different cell it always takes the value from A1.

If you don't understand what I mean, have a look here

http://office.microsoft.com/en-us/excel-help/switch-between-relative-absolute-and-mixed-references-HP003064048.aspx?pid=CH010036991033

littlepanther

The dollar signs are for absolute referencing, this means that when you copy the formula the reference to the cell with the dollar signs does not change.

The dollar sign only needs to go in front of the column or row reference that is going to change, although in your instance putting it in front of both is more than likely ok. For example, if copying down only you could enter A$1, and if copying across only $A1. If in doubt and referring to only one cell put the dollar signs in front of both as you have done.

A quick shortcut is once you have put the cell reference into your formula press the F4 key and it will out the dollar signs in for you. Each time you press F4 it will do a different combination of dollar signs.