Hi

I have this formula that is suppose to look at two fields and determine if both are under the value, if the values are under the other value then it should write MFG DEFECT in the txtfields(8).

If Val(txtFields(5).Text) < 7.2 And Val(txtFields(7).Text) < Val(txtFields(4).Text) Then
txtFields(8) = "MFG DEFECT"
End If

It does not do that though, actually it doesn't do anything. I was wondering if someone could help me out with this?

Thanks

jeffro