G
Guest
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?
=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?