Y yonkersmike Mar 13, 2010 #1 i want to come up with a formula where cell b1 *.00125 if its less than 100, the value must show min 100.00
i want to come up with a formula where cell b1 *.00125 if its less than 100, the value must show min 100.00
× ×ž×™×›×ל (מיקי) ×בידן Mar 13, 2010 #2 In C1 type: =IF(B1*0.00125<100,100,B1*0.00125) Micky