I'm not quite sure exactly what you want. Could you describe exactly what you
would like to see happen, including which logical tests should take
precedence?
Or, you may want to look in the Help Files at the OR and AND Functions.

tj

"Roccobarocco" wrote:

Can anyone correct the following formula:

=IF(J20="w",a!BT20,IF(J20="l",a!BT20,IF(J20="x",0, IF(J20="",a!BT20,0,if(K20="X",0))))

,or suggest an alternative?