Hi

=IF(J20="x","",IF(OR(J20="w",J20="l",J20=""),a!BT2 0,IF(K20="X",0,"")))


Arvi Laanemets


"Roccobarocco" wrote in message
...
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?