The Chief,

I'm not sure what you're trying to accomplish here, and this may be usage I've never encountered before, but there are some parts of your formula that don't make sense:

1) You're multiplying C60 by a logical statement. In essence, you're taking the value of C60 * either TRUE or FALSE. This is fine in essence, but I don't think it's doing what you intend it to.

2) The second argument in your AND statement ("60") is always TRUE. 60 is always 60, so there's no reason to include it in a logical statement.

3) The result of the condition in your IF statement (based on the two above) is that your condition will ALWAYS give you M6/6 unless "50" is entered in S24.

4) Because of 3) above, there is no reason to include C60 in the formula. It serves no purpose.

From the looks of your formula, what you want it to do is multiply C60 by M6 divided by S24 divided by 10. If this is the case, use this formula:

=C60*(M6/(S24/10))

Let me know if I've misunderstood your intention.

Knightly