Results 1 to 3 of 3

How could i abbreviate this Nested IF?!

Threaded View

  1. #1
    Registered User
    Join Date
    11-01-2012
    Location
    Cairo, Egypt
    MS-Off Ver
    MS Office 2013
    Posts
    76

    Exclamation How could i abbreviate this Nested IF?!

    Hi,

    I'm using Nested_IF to perform these multiple logical test ...

    =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))))))
    I just wonder if there is any other way to perform this action with shorter formula?
    The example is attached
    Thanks in advance.

    ______________________
    S.U.B.V.E.R.T.E.R
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1