Filling a Formula

  • Thread starter Thread starter mx-3 for me
  • Start date Start date
M

mx-3 for me

Hi there, im working on a rather large spreadsheet that will have abou
8,000 entries in the end. I want to be able to fill the values throug
instead of having to correct each formula. This is my problem: I a
copying and pasting a formula from another sheet, because the othe
sheet references to itself, I have to correct where the forumla i
referencing to. However, when I use the fill function it i
incrementing the cell values when I dont want it to, or simply makin
up its own pattern that I am not following for this sheet. The formul
goes as follows
=IF(OR((C10/100)<HOUR(Sheet1!$D6),(C10/100)>HOUR(Sheet1!$E6)),Sheet1!$H6,IF(AND((C10/100)>HOUR(Sheet1!$D6),(C10/100)<HOUR(Sheet1!$E6)),0,IF((C10/100)=HOUR(Sheet1!$D6),(MINUTE(Sheet1!$D6)/60)*Sheet1!$H6,((60-MINUTE(Sheet1!$D6))/60)*Sheet1!$H6)))
I want all of the H6's and D6's to stay the same for every chunk of 2
cells that I fill under, however I want the C10's to increment for eac
cell that I fill. Is there any possible way to do this? This is s
HARD!!! PLEASE any help would be soooo much appreciated. Thanks!
Michell
 
I have not really looked at your formula, but a general rule in force when
copying formulas, as far as the changing of cell references, is as follows:

Relative references (column & row), *will* change when copied to another
cell.
Absolute references *will not* change.

Relative references = A1 - A2 - B1 - B2
Absolute references = $A$1 - $A$2 - $B$1 - $B$2

Now, there can be *mixed* references, where the column *or* the row will or
will not change with copying.

$A1 - A$1 - $B1 - B$1

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi there, im working on a rather large spreadsheet that will have about
8,000 entries in the end. I want to be able to fill the values through
instead of having to correct each formula. This is my problem: I am
copying and pasting a formula from another sheet, because the other
sheet references to itself, I have to correct where the forumla is
referencing to. However, when I use the fill function it is
incrementing the cell values when I dont want it to, or simply making
up its own pattern that I am not following for this sheet. The formula
goes as follows
=IF(OR((C10/100)<HOUR(Sheet1!$D6),(C10/100)>HOUR(Sheet1!$E6)),Sheet1!$H6,IF(
AND((C10/100)>HOUR(Sheet1!$D6),(C10/100)<HOUR(Sheet1!$E6)),0,IF((C10/100)=HO
UR(Sheet1!$D6),(MINUTE(Sheet1!$D6)/60)*Sheet1!$H6,((60-MINUTE(Sheet1!$D6))/6
0)*Sheet1!$H6)))
I want all of the H6's and D6's to stay the same for every chunk of 24
cells that I fill under, however I want the C10's to increment for each
cell that I fill. Is there any possible way to do this? This is so
HARD!!! PLEASE any help would be soooo much appreciated. Thanks!
Michelle
 
Back
Top