Complex IF STATEMENT

  • Thread starter Thread starter Caliban
  • Start date Start date
C

Caliban

Thanks for your previous advice, it worked like a charm!

Normal syntax, as you so kindly pointed out, is =IF(logical_test,
value_if_true,value_if_false)

I now have a situation where I have 3 ranges of numbers nominated by myself,
for example 1-3, 3-6, 2-5.

I want to test these ranges against 3 actual numbers which are generated by
a situation beyond my control. If the three numbers ALL consecutively fall
within each range I want to generate a value_if_true, otherwise produce a
value_if_false. For example:

Numbers 1, 4 & 2:
1(1-3), 4(3-6), 2(2-5) would be TRUE (as all numbers fit within their
allotted range)

Numbers 3, 8 & 3:
3(1-3), 8(3-6), 3(2-5) would be FALSE (as 8 is beyond its allotted range
3-6)

It seems I need to apply maybe six logical tests, ALL of which must be
passed to achieve a TRUE value, with any failure resulting in a FALSE value.

The syntax would be something like: =IF(logical test1,logical
test2........logical test6, value if true, value if false)

I think, if I've explained myself clearly enough, I need to know the right
syntax for combining the logical tests into a greater logical argument
resulting in a true or false situation.

Maybe =IF(logical test1 AND logical test2 AND...... etc. ?????

Help!
 
Back
Top