Linking a formula function between sheets

[Paulcassin]

I am attempting to insert a formula function from one sheet to another. I have inserted the formula into the destination sheet. It’s works fine for the first cell. When I drop the formula down the column the dollarised amounts used in the formula spreadsheets ‘scatters’ . What I mean is when a dollarised cell in the origin sheet say B3 is inserted into the destination sheet it transfers as C4 and the incorrect answer appears. Anyone got any ideas?

 

[James006]

Hello,

Are you talking about ' absolute reference ' ...???

Why don't you ... at the very least ... post your formula ..???

 

[Paulcassin]

ok here they are:

=IF(B4<=$F$4,$F$4*$G$5,IF(AND(B4>$F$4,B4<=$F$8),$F$4*$G$5+(B4-$F$4)*$H$4,IF(AND(B4>100,B4<=1000),$F$4*$J$9+($B$4-$F$4)*H9)))

AND

=IF(B4<=$F$4,$F$4*$G$4,IF(AND(B4>$F$4,B4<=F8),$F$4*$G$4+(B4-$F$4)*$I$4,IF(AND(B4>$E$9,B4<=$F$9),$F$4*$K$9+(($B$4-$F$4)*$I$9))))

In my formula spredsheet if B4 is 100KM it computes the correct prices $325 and $225.

When the formulas are inserted in the other sheet and then dropped down the column the results produced are incorrect.

Hope you can help

 

[James006]

Hello,

For all your absolute references ... you do need to add the sheet name ... such as

=Sheet1!$F$4

Hope this will help