If you enter 5B21C2 in cell B1, the
formula is replaced by the number 125 when you press enter. What
happened?

How about Tools | AutoCorrect ? where Excel is changing the Text "5B21C2"
into the number 125?
You are entering text, especially since you are not entering a "=" first.
However, we know it's not a function because (1) it would be entered as
"=5B21C2", and (2) a function name can not start with a number.
If you do enter it as "=5B21C2", Excel asks to change this meaningless
address to its best guess of =BC5212.

--
Dana DeLouis
Win XP & Office 2003


"rlrlatr35" wrote in message
...
I am taking a class & need help with this question. If you enter 5B21C2 in
cell B1 of a worksheet (keep in mind it's a make believe worksheet), the
formula is replaced by the number 125 when you press enter. What
happened?
Second part is using the worksheet from above, you change the number in
cell
B2 from 55 to 65. What happens to the number in the cell B1? Why? I
can't
find anywhere in the book how to (+,-* or /) or any other math direction
involving a formula like above. Due to that I have no idea how to answer
either one of these questions. Please Help!
--
thanks