Formula on the right

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A B C D
E

1 25 30 25*30 100*100
10*10
2 100 100 100*100
3 10 10 10*10

WHEN THE FORMULA IS DRAGGED FROM C1 TO DOWN SAME FORMULA IN COPIED HOWEVER
WHEN THE C1 FORMULA IS DRAGGED ONTO THE RIGHT THIS DOES NOT HAPPEN, WHY AND
HOW?
 
I'm not sure I fully understand but have a look at the formula below:-

=A$1+A$2

The $ sign makes it stays the same when dragged down but if it is dragged
right then the column letter changes.

Mike
 
Back
Top