Results 1 to 6 of 6

Long Nested IFs

Threaded View

disturbed Long Nested IFs 02-12-2011, 02:00 AM
protonLeah Re: Long Nested IF's, Can It... 02-12-2011, 02:34 AM
disturbed Re: Long Nested IF's, Can It... 02-12-2011, 02:52 AM
disturbed Re: Long Nested IF's, Can It... 02-12-2011, 03:11 AM
DonkeyOte Re: Long Nested IF's, Can It... 02-12-2011, 04:45 AM
disturbed Re: Long Nested IF's, Can It... 02-12-2011, 04:59 AM
  1. 02-12-2011, 02:00 AM #1
    disturbed is offline
    Registered User
    Join Date
    02-12-2011
    Location
    California
    MS-Off Ver
    Excel 2003 & 7
    Posts
    5

    Question Long Nested IFs

    Hi Excel Wizzards !

    I have this long nested IF that I was wondering.. does it need to be so darn long, or can it somehow be trimmed down with smarter formula?

    =IF(RIGHT(F19,1)="B","HI RACK "&C19,IF(RIGHT(F19,1)="C","HI RACK "&C19,IF(RIGHT(F19,1)="D","HI RACK "&C19,IF(RIGHT(F19,1)="E","HI RACK "&C19,IF(RIGHT(F19,1)="F","HI RACK "&C19,"FLOOR "&C19)))))

    I was thinking something like this would be nice:

    =IF(RIGHT(F19,1)={"B","C","D","E","F"},"HI RACK "&C19,"FLOOR "&C19)

    F19 is a position in a Pallet Rack. A is 'floor' level, B,C,D,E,F are overhead (hi rack) levels. C19 is the company code that owns the products.
    Last edited by disturbed; 02-12-2011 at 05:42 AM. Reason: solved
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1