In C1 type: =IF(B1*0.00125<100,100,B1*0.00125)
Micky


"yonkersmike" wrote:

i want to come up with a formula where cell b1 *.00125 if its less than 100,
the value must show min 100.00