formula correction

R

Roccobarocco

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?
 
T

tjtjjtjt

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
 
A

Arvi Laanemets

Hi

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


Arvi Laanemets
 
R

Ron Rosenfeld

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?
Click to expand...

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(K20="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
 
R

Ron Rosenfeld

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

That should read "... J20 and K20 might contain ..."


--ron
 
Top