Hi guys im struggling again
how can you say the following:
if any of the C17,18, E16, E17G16,G17,I16,I17 ARE 0-3 THEN 0, 4-20 THEN 1, 20+ THEN 2
=+IF(OR(Summary!$C$17<=3,Summary!$C$18<=3,Summary!$E$16<=3,Summary!$E$17<=3,Summary!$G$16<=3,Summary!$G$17<=3,Summary!$I$16<=3,Summary!$I$17<=3),0,IF(OR(Summary!$C$17<=20,Summary!$C$18<=20,Summary!$E$16<=20,Summary!$E$17<=20,Summary!$G$16<=20,Summary!$G$17<=20,Summary!$I$16<=20,Summary!$I$17<=20),1,IF(OR(Summary!$C$17>=21,Summary!$C$18>=21,Summary!$E$16>=21,Summary!$E$17>=21,Summary!$G$16>=21,Summary!$G$17>=21,Summary!$I$16>=21,Summary!$G$17>=21),2,)))
How do you say the same with and?
thanks a lot
Bookmarks