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) |
Syntax is =IF(OR(condition1,condition2,condition3,...),value if true,value if
false) -- that is, only ONE "OR" would be in the formula. Not sure what you're trying to accomplish here. "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) |
All times are GMT +1. The time now is 04:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com