How do figure excel formula out?
 

I'm taking an excel class & the ? is "if you enter 5B21C2 in cell B1 of a
worksheet the formula is replaced by the # 125 when you press enter. What
happened? The worksheet is hypethetical. Then the next ? is to use same
worksheet, change the # in cell B2 from 55 to 65. What happens to the # in
cell B1 & why. The info I found doesn't tell how to figure the first formula
so everything else doesn't make sense to me. HELP!
--
thanks

I'm sorry to say that your comprehension of XL is soooo bad, that you can't
pose an accurate, intelligent question.

Does 5B21C2, in *exactly* that form, mean something to you, pertaining to
XL???
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rlrlatr35" wrote in message
...
I'm taking an excel class & the ? is "if you enter 5B21C2 in cell B1 of a
worksheet the formula is replaced by the # 125 when you press enter. What
happened? The worksheet is hypethetical. Then the next ? is to use same
worksheet, change the # in cell B2 from 55 to 65. What happens to the #
in
cell B1 & why. The info I found doesn't tell how to figure the first
formula
so everything else doesn't make sense to me. HELP!
--
thanks

"rlrlatr35" wrote...
I'm taking an excel class & the ? is "if you enter 5B21C2 in cell B1 of a
worksheet the formula is replaced by the # 125 when you press enter. What
happened? The worksheet is hypethetical. Then the next ? is to use same
worksheet, change the # in cell B2 from 55 to 65. What happens to the # in
cell B1 & why. The info I found doesn't tell how to figure the first
formula so everything else doesn't make sense to me. HELP!

I suppose 5B21C2 could be an Islamic calendar date, and 125 it's
representation in General number format. That's all I can think of.