Hi,
I'm using Nested_IF to perform these multiple logical test ...
I just wonder if there is any other way to perform this action with shorter formula?![]()
=IF(AND($F1>=$A$1;$F1<=$B$1);$C$1;IF(AND($F1>=$A$2;$F1<=$B$2);$C$2;IF(AND($F1>=$A$3;$F1<=$B$3);$C$3;IF(AND($F1>=$A$4;$F1<=$B$4);$C$4;IF(AND($F1>=$A$5;$F1<=$B$5);$C$5;IF(AND($F1>=$A$6;$F1<=$B$6);$C$6))))))
The example is attached
Thanks in advance.
______________________
S.U.B.V.E.R.T.E.R
Bookmarks