How funny can XL be?

P

Pecoflyer

I entered three random values in a1-c1 and summed them up in D1
hen, selected A1-D1 and dragged along the row.
H1 does give the sum of E1-G1, but where do these cells get there
values?


+-------------------------------------------------------------------+
|Filename: Funny.xlsx |
|Download: http://www.thecodecage.com/attachment.php?attachmentid=3 |
+-------------------------------------------------------------------+
 
B

Bernie Deitrick

When you dragged the cells along the row, Excel may have auto-increment the
values based on what it sees as the pattern you have entered.

HTH,
Bernie
MS Excel MVP
 
S

ShaneDevenshire

Hi,

Further clarification, if necessary:

You have 3 cells with number and the fourth cell sums those three numbers.
Now you drag to the right and Excel figures you want to copy what is in those
cells to corresponding positions. So E1 is a copy of A1, F1 is a copy of B1,
G1 is a copy of C1 and H1 is a copy of D1. A1:C1 have random numbers so
E1:G1 have random numbers (or Excel's linear regression calculation of those
numbers) and H1 has a copy of D1 which is a relative formula saying sum the
three cells to the left. E1:G1.
 
P

Pecoflyer

Thx for your explanatio
I'll have a look at the linear regression thing ( long way back
 
Top