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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to display cell address 2
Combine 2 formulas 14
Need urgent help with SUMPRODUCT() 8
match 3
Returning $ values by start & finish dates only 7
how to countif when using indirect cell 1
Excel Write a formula in excel where 1 = .05, 2 = .75, 3 = .30 etc. 4
Calculate sum of values based on a ref value, how? 4

Back
Top