Basic Formula question

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

Guest

This is a very basic question, but I can't seem to remember how to do it. I
am trying to make a row of formulas reference one set cell, and one cell that
moves as I move up the row (ie formula 1) B4/C6, 2) B5/C6 3) B6/C6). Can
anyone refresh my memory on how to make the formula do that? Everytime I
move up a cell, the second indicator also moves up a cell.
 
you need to use $ ie B4/$C$6 and use the fill handle
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
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

Need HELP!! IF OR formula driving me crazy!!!! 8
Expanding Date formula 1
Excel Formula Help 5
solving nested IF statements 13
MACRO SELECT COLUMN 2
string function help 5
Why doesn't excel count function update automatically? 1
excel 2003 spreadsheet scrolling 1

Back
Top