I have the following expression in my report that is working correctly:
=IIf([product_compare_cost1]<[product_cost] And [product_compare_cost1]<[product_compare_cost2] And [product_compare_cost1]<[product_compare_cost3] And [product_compare_cost1]<[product_compare_cost4] And...