Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 "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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
On Sun, 05 Dec 2004 17:01:29 -0500, Ron Rosenfeld
wrote: Note that there are a number of things that J20 might contain that are undefined, in which case the formula will return FALSE. That should read "... J20 and K20 might contain ..." --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |