Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
I cant seem to figure out how to use Proper in excel. The help op. | Excel Discussion (Misc queries) | |||
Excel: To Display Formula in the cells Instead of Value | Excel Discussion (Misc queries) | |||
Preserve Excel formula entry | Excel Discussion (Misc queries) |