Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to create an equation that calculates the amount of native currency using an absolute cell reference formula. I am doing an assignment and it requires me to find the native currency of $1 equivalent to these 7 different counrtries. AUSTRIA, BELIZE, CHILE, CZECH REPUBLIC, SWEDEN, THAILAND, AND UKRAINE. I am having the hardest time trying to figure out how to get the correct answers when I due the work. Please someone help me out. Thanks so much...

share|improve this question
show us what you tried, what are your inputs and expected outputs. Your question as stated here is really unclear – JMax Feb 20 '12 at 8:25

An absolute cell reference is referred to by using $.

  • $A1 is an absolute reference to column A but the row can change.
  • A$1 is an absolute reference to row 1 while the column can change.
  • $A$1 is an absolute reference to both column A & row 1.

If you want anything more than that, edit your question to let us know what you have tried and exactly which part you are having a problem with.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.