On Sun, 5 Dec 2004 12:59:05 -0800, 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?

Perhaps:

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

or (simpler):

=IF(OR(J20={"w","l",""}),a!BT20,IF(J20="x",0,IF(K2 0="X",0)))

Note that there are a number of things that J20 might contain that are
undefined, in which case the formula will return FALSE.



--ron