If any of 3 cells is in any one of 3 ranges, then

[aramg83]

Hello All. Hope you can help. I'd like to express something like this:

If 0<B4 or C4 or D4 <=24, then output 14. If 24<B4 or C4 or D4 <=36, then output 12. If B4 or C4 or D4 > 36, then output 10.

Thanks

[martindwilson]

If 0<B4 or C4 or D4 <=24 ?????
does that mean
and b4 is greater than 0 and either c4 or d4 is less than or equal to 24
or does it mean
or b4 is greater than 0, or c4 less than or equal to 24 or d4 is less than or equal to 24

[Motu040602]

try

---if(or(B4>0,C4>0,D4>0),14,if(or(B4>24,C4<=36,D4<=36),12,if(or(B4>36,C4>36,D4>36),10,"")))---

This assuming you want the answer in one cell!