function symbols

[Toni]

What is the symbol for the inflation rate in excel?

 

[Chip Pearson]

Toni,

There isn't a symbol. Are you thinking of the RATE function?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Toni]

one of my classes is on excel and we had a test with one
question stating:
"22. Assume you are creating a worksheet to calculate
projected earnings. You expect to create and copy several
formulas using the inflation rate, which is found in cell
C6. Since the inflation rate will always be in cell C6,
the formulas referencing the cell should show:
a)C6
b)$C$6
c)&C&6
d)@C@6
And I have search the book and all the excel help but
found nothing! Do you know the answer?

 

[Dave Potter]

The answer is b.

one of my classes is on excel and we had a test with one
question stating:
"22. Assume you are creating a worksheet to calculate
projected earnings. You expect to create and copy several
formulas using the inflation rate, which is found in cell
C6. Since the inflation rate will always be in cell C6,
the formulas referencing the cell should show:
a)C6
b)$C$6
c)&C&6
d)@C@6
And I have search the book and all the excel help but
found nothing! Do you know the answer?

 

[Chip Pearson]

The answer is "C" but has nothing whatsoever to do with inflation.
The use of the dollar signs in the cell reference causes it to be
"absolute", meaning that it will not change when you copy/paste
the cell or when you use the Fill edit tools. See
http://www.cpearson.com/excel/relative.htm for a brief discussion
of relative and absolute cell references.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Dave Potter]

The $ is used to create an absolute cell reference

 

[David McRitchie]

Or the test is incorrect since the correct answer is obviously <grin>
=INDIRECT("C6")
if you want to take always in cell C6 literally.