Linerar equation woes

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

Gerry

Hi... Frank,
can this linear equation you provided be prevented from
going to negative values while the column G is still
postive... this is from;

Original thread 4/28/2004 9:38:54 AM

And my new post comments
=G2*(($J$1-$I$1)/($G$62-$G$25))+($I$1-$G$25*(($J$1-$I$1)/
($G$62-$G$25))) copied down.
I get -numbers from G5 to G2.

TIA
 
Hi Gerry
and your expected result would be?
Some workarounds (but mathematically probably not correct):
=MAX(G2*(($J$1-$I$1)/($G$62-$G$25))+($I$1-$G$25*(($J$1-$I$1)/
($G$62-$G$25))),0)

or
=G2*(($J$1-$I$1)/($G$62-$G$25))+MAX(($I$1-$G$25*(($J$1-$I$1)/
($G$62-$G$25))),0)
 
Hi Frank,
The value for 1.00 cm down to .25 cm should be a positive
value but I know that the incremental approach will not
show this. Perhaps the best thing to state is a set number
after this size!
The value chart I am creating is for an evaluation form.
The size I replace with is (6.0 cm, set at $350) and
(15.25 cm; $1000, is market size and cost for the largest
I can get). The values (other than $350.00) is an
appraised value.
Thanks for all your help. If you have another idea please
post!
 
Back
Top