|
Hi Manuel,
I'm not sure I understand what you want, but the
table you've provided is a straight line function, so any two points will give
you the slope of the line by calculating (y1-y2)/(xi-x2). >From that
you can calculate the zero discount value of x or any other point on the
line.
Dave Billing
Tall Tree Business Solution
----- Original Message -----
Sent: Monday, July 08, 2002 11:33
AM
Subject: HOW
Hello Everyone.
Can someone help me with this
problem?
At any one time I will have a selling price and a discount
value
HERE IS A TABLE OF
VALUES
PRICE
%DISCOUNT
3.70
0
5.00
-35.1351
4.00
-8.11
3.00
18.92
2.00
45.95
3.33
10
1.85
50
Ok
here is what I need.
What is the Price when the discount is
0?
To put is in another way...................
If I have a Price of
$2.00 and a discount of 45.95% how can I compute and get the $3.70
value.
If you change the price it re-computes the
discount based on the price @ 0% discount.. It also computes the selling
price base on an entered discount. The only way that I see of doing this
is by first finding the selling price with no discount and then
computing the new value, either discount or selling price based on the obtains
price at zero discount.
I have a feeling this is 8th. grade algebra but
I have been going in circles, feeling pretty dumb, this weekend
.
Thanks,
Manuel
|
