Costs Comparison and Generate Rate

[sorpasso]

Hi,

I am trying to find the way to compare products costs between 3 vendors against mine and generate a sell rate with the best profit possible. So, for example the best competitor cost is $1 and mine is $ 0.50, I want to generate a rate to be close and below to $1. Do you know any macro or formula for it? The trick is that my costs may be higher than any of these vendors' cost in certain products.


Thanks,
Sorpasso

 

[sorpasso]

I am not sure how much I was able to help, but you are welcome!

You helped me a lot, Joe4. I can live with the way you presented your solution. Have a great rest of the week!


Thanks,
Sorpasso