How do figure excel formula out?

G

Guest

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!
 
R

Ragdyer

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???
 
H

Harlan Grove

rlrlatr35 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top