excell

Y

yonkersmike

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

מיכ×ל (מיקי) ×בידן

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