| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula entered not working
In one particular cell where I have a simple formula in C1
=A1-B1 where A1 is 2005 and B1 is 1 (both are text formated) gives the right answer. But the formula in cell C2 which is equal to =C1-B1 where C1 is 2005 in text BUT This time B1 is 01 in number doesn't work. When I type this formula in C2, the answer remains as =C1-B1 not an answer, but the string "=C1-B1" Anyone understand why? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Formula not working | Excel Worksheet Functions | |||
| Formula to calucate # of months based on a speificed date entered | Excel Worksheet Functions | |||
| Excel: Formula worked last week but now stoppped working. | Excel Worksheet Functions | |||
| Excel formula not working | Excel Discussion (Misc queries) | |||
Threaded Mode
