Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
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) |
#4
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Sum If Multiple Conditions | Excel Worksheet Functions |