LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 41
Default Bug in Excel?

Hi,
Using a simple formula "SUM" the formula change himself
Test this anywhere in a sheet: For this example I will use A1 to A15
In cells A16 type: =sum(A1:A10)
In Cells A17 Type: =sum(A11:A15)
Now start to type number 1 in cell A1 than A2 and so on.
The sum in cell A16 are ok until you reach A10
If you type 1 in row A11 the sum in cell A17 show 1 and now the formula in
cellA16 change himself and show 11 instead of 10.
a1 1
a2 1
a3 1
a4 1
a5 1
a6 1
a7 1
a8 1
a9 1
a10 1
a11 1
a12
a13
a14
a15
11 This is at the beginning =sum(A1:A10) After entering the 1 in the cell
A11 the formula change
1 This is at the beginning =sum(A11:A15)

Do you have a patch for this or this is new ?
Bye







 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"