+ Reply to Thread
Results 1 to 5 of 5

Nested IF/THEN Formula - 5 Deep I believe

  1. 02-06-2015, 11:27 AM #1
    jemmers
    jemmers is offline
    Registered User
    Join Date
    01-16-2013
    Location
    Oklahoma City, OK
    MS-Off Ver
    Excel 2010
    Posts
    40

    Nested IF/THEN Formula - 5 Deep I believe

    Book1.xlsx

    Hello All,

    I need some help with a nested IF/THEN statement that goes in each cell of the F column.


    If there are over 24 units sold, please keep in ready: # units sold/3

    If there are over 20 units in stock please keep a minimum of 8 in ready

    If there are under 20 units in stock please keep a minimum of 5 in ready

    Please adjust the # of units needed in ready to the amount we have in stock if the amount we have in stock is lower then the amount we need in ready.

    Also, if both Ready and total stock are 0, then move to ready should be 0

    Any help would be greatly appreciated.

    Thank you,
    Jennifer

    Attachment 375575
    Last edited by jemmers; 02-06-2015 at 01:46 PM. Reason: Add attachment
    Reply With QuoteRegister To Reply
  2. 02-06-2015, 12:24 PM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,890

    Re: Nested IF/THEN Formula - 5 Deep I believe

    Your attachment doesn't seem to work. While you are composing a post, click on Go Advance at the bottom of the Edit window, then scroll down and click on Manage Attachments (or click on the paperclip icon), then follow the on-screen prompts.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 02-06-2015, 12:52 PM #3
    jemmers
    jemmers is offline
    Registered User
    Join Date
    01-16-2013
    Location
    Oklahoma City, OK
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Nested IF/THEN Formula - 5 Deep I believe

    Okay, I think I added it on the first post. Thank you!
    Reply With QuoteRegister To Reply
  4. 02-06-2015, 01:27 PM #4
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,890

    Re: Nested IF/THEN Formula - 5 Deep I believe

    Try this formula:

    =IF(C2>24,MIN(INT(C2/3),D2),IF(C2>20,MIN(8,D2),MIN(5,D2)))

    then copy down.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  5. 02-06-2015, 01:46 PM #5
    jemmers
    jemmers is offline
    Registered User
    Join Date
    01-16-2013
    Location
    Oklahoma City, OK
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Nested IF/THEN Formula - 5 Deep I believe

    That got it, thank you so much!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 2003 Excel formula - add each cell in the 6th row of a column 6,744 rows deep?
    By [email protected] in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-12-2013, 09:58 AM
  2. External Links nested more than one deep
    By Raziaar in forum Excel General
    Replies: 0
    Last Post: 09-06-2013, 06:22 AM
  3. Calculating Variable deep within formula
    By Texans57 in forum Excel General
    Replies: 2
    Last Post: 11-15-2012, 10:53 PM
  4. too deep formula line
    By Light in forum Excel General
    Replies: 5
    Last Post: 03-17-2006, 03:20 PM
  5. [SOLVED] DEEP IN MUD
    By Ronald Cayne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2005, 06:06 PM

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