Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula on the right
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula on the right
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 "tracing precedent by double clicking cel" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|