excell
 

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

excell
 

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

excell
 

=MAX(B1 *0.00125,100)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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