Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need help figuring out this formula in Excel
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 |
#2
|
|||
|
|||
It sounds like there is event code that is monitoring the cell (or cells),
and stripping out any non-numeric characters. With the information provided, there is nothing to show that B1 would change if B2 is changed. -- HTH RP (remove nothere from the email address if mailing direct) "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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
there could be event code attached to the cell (leave
event) that converts the 5B21C2 from Hexidecemal to decimal then performs some other translation. Try this in cell C1 "=HEX2DEC(B1)/47779.344" It might be a starting point for you. Good luck! -----Original 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do figure excel formula out? | Excel Discussion (Misc queries) | |||
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) | |||
Preserve Excel formula entry | Excel Discussion (Misc queries) |