Formula help (increment)

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

Hi,
I would help in developing a formula to place values along
side sizes down a column when I know two size's values
(these are fixed)?

Example:
In G2 I have 1.27 (G3 is 2.54)(G4 is 3.81)(G5 is 5.08)up
to (G13 which is 15.25)

In I1 the known value for G5 (in H5) is $350.00
In J1 the known value for G13 (in H13) is $1000.00
I1 and J1 can change from time to time.

How can I apply a formula to column H to incrementally
place a value by looking at I1 and J1 and considering the
change in cm sizes?

TIA
 
Hi
seems to be a linear equation. Use the following formula in H2
=G2*(($J$1-$I$1)/($G$13-$G$5))+($I$1-$G$5*(($J$1-$I$1)/($G$13-$G$5)))
 
Hi Frank,
Thank you! That worked great for me!
I request some advice as when I expand my increments I get
some negative numbers while I'm in positive values for cm.

My problem:
I now am dealing with G2 is .25 and G62 is 15.25 with
progressive increments of .25 cm
I1 $350.00 entered now applies to 6.0 cm at G25.
H1 $1000.00 entered now applies to 15.25 cm at G62
I modified your formula to read
=G2*(($J$1-$I$1)/($G$62-$G$25))+($I$1-$G$25*(($J$1-$I$1)/
($G$62-$G$25))) copied down.
but get -numbers from G5 to G2.
Those few numbers theoretically should still have some +
value.

Please advise!
 
Back
Top