Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I am doing something obviously stupid but can't see what In a spreadsheet I have data in cols A and B In cell B1 I have =(a1-0.375) I have copied this to b2.b14 with the result shown: 1 0.625 2 0.625 3 0.625 4 0.625 5 0.625 6 0.625 7 0.625 8 0.625 9 0.625 10 0.625 11 0.625 12 0.625 13 0.625 14 0.625 If I go to cell b2 and then left click in the formula bar then hit enter, b2 evaluates to 1.625. Same with b3, b4 etc. What have I done to stop the formula evaluating correctly after I have copied it? Thanks Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple Rounding Problem | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Problem with date base units for x axis | Charts and Charting in Excel |