loop verifycation...

[jojofv]

hallo everyone,

i have Transaction table like below
ID Prod Name Selling Price
1 ABCD1 $101
2 ABCD2 $112
3 ABCD3 $125
..
..
19 ABCD19 $123
20 ABCD20 $105

so in that table the selling price range from $101-
$125.now if i want to get the quantity(with '0' on last
number) for every record such that if i multiply it and it
still in the range of Total Price by +/- 15%. let me give
you example.

input >> Total Price $100,000
so +/- 15% would be $85,000-$115,000
then the lowest Total price/lowest price: $85,000/
$101=841.6
thus i should pick 850 and when i verify with high price;
850*$125=$106250
So in this case i should pick 850 as the quantity

anyone can help me how to achieve that?

TIA
jojofv

 

[Chris Nebinger]

I think I understand:


cint((([Enter Total Price] *.85)/DMIN
("SellingPrice","TransactionTable"))/10)*10


That should work.


Chris Nebinger