multiple or conditions
 

I have written syntax that doesn't seem to be picking up all my or conditions
thus leaving me with an inaccurate answer. What am I doing wrong?

=IF($I52.5,1,0)*OR($K52.5,1,0)*OR($M52.5,1,0)*O R($O52.5,1,0)
*OR($Q52.5,1,0)*OR($J55,1,0)*OR($L55,1,0)*OR($N 55,1,0)
*OR($P55,1,0)*OR($R55,1,0)

Look in HELP index for the proper syntax for OR

--
Don Guillett
SalesAid Software

"lschuh" wrote in message
...
I have written syntax that doesn't seem to be picking up all my or
conditions
thus leaving me with an inaccurate answer. What am I doing wrong?

=IF($I52.5,1,0)*OR($K52.5,1,0)*OR($M52.5,1,0)*O R($O52.5,1,0)
*OR($Q52.5,1,0)*OR($J55,1,0)*OR($L55,1,0)*OR($N 55,1,0)
*OR($P55,1,0)*OR($R55,1,0)

try instead
=if(or($I52.5,$K52.5,$M52.5,$O52.5,$Q52.5,$J5 5,$L55,$N55,$P55,$R55),1,0)
Your logic was fine, just the format of how to use the or was off. (If I
thought about it, I could probably guess what Your spread sheet background is)

"lschuh" wrote:

I have written syntax that doesn't seem to be picking up all my or conditions
thus leaving me with an inaccurate answer. What am I doing wrong?

=IF($I52.5,1,0)*OR($K52.5,1,0)*OR($M52.5,1,0)*O R($O52.5,1,0)
*OR($Q52.5,1,0)*OR($J55,1,0)*OR($L55,1,0)*OR($N 55,1,0)
*OR($P55,1,0)*OR($R55,1,0)

The format is

=IF(OR(condition1, condition2, condition3, ...), action1, action2)

--
HTH

Bob Phillips

"lschuh" wrote in message
...
I have written syntax that doesn't seem to be picking up all my or
conditions
thus leaving me with an inaccurate answer. What am I doing wrong?

=IF($I52.5,1,0)*OR($K52.5,1,0)*OR($M52.5,1,0)*O R($O52.5,1,0)
*OR($Q52.5,1,0)*OR($J55,1,0)*OR($L55,1,0)*OR($N 55,1,0)
*OR($P55,1,0)*OR($R55,1,0)