View Single Post
  #1   Report Post  
Roccobarocco
 
Posts: n/a
Default formula correction

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?