+ Reply to Thread
Results 1 to 5 of 5

Simplifying excel equation

  1. #1
    Forum Contributor
    Join Date
    03-27-2013
    Location
    Dubai
    MS-Off Ver
    MS365 Version 2301
    Posts
    118

    Simplifying excel equation

    Dear all,

    I did an equation in column F, which includes many COUNTIF and AND equations.

    I need to simplify it or please advice me with another equation in column F in Min Stock sheet

    The equation should searches in
    Dimension from D4 till D20 in Min Stock sheet
    sheet Rules: if the branches from A2 till A37 in Rules sheet = B1 in Rules sheet
    and the sales <=1 the Min Stock column F: should result 2.
    and the sales <=2 the Min Stock column F: should result 3.
    and the sales <=3 the Min Stock column F: should result 4.
    and the sales more than of equal to 4 the Min Stock column F: should result 5.

    Then
    Dimension from D21 till D24 in Min Stock sheet
    sheet Rules: if the branches from A2 till A37 in Rules sheet = B1 in Min Stock sheet
    and the sales <=1 the Min Stock column F: should result 1.
    and the sales <=2 the Min Stock column F: should result 2.
    and the sales <=3 the Min Stock column F: should result 3.
    and the sales more than of equal to 4 the Min Stock column F: should result 4.

    Then
    Dimension from D4 till D20 in Min Stock sheet
    sheet Rules: if the branches from A38 till A65 in Rules sheet = B1 in Min Stock sheet
    and the sales <=1 the Min Stock column F: should result 1.
    and the sales <=2 the Min Stock column F: should result 2.
    and the sales <=3 the Min Stock column F: should result 3.
    and the sales more than of equal to 4 the Min Stock column F: should result 4.

    Then
    Dimension from D21 till D24 in Min Stock sheet
    sheet Rules: if the branches from A38 till A65 in Rules sheet = B1 in Min Stock sheet
    the Min Stock column F: should result 0.

    Then
    Dimension from D4 till D24 in Min Stock sheet
    sheet Rules: if the branch A66 in Rules sheet = B1 in Min Stock sheet
    the Min Stock column F: should result 0.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,139

    Re: Simplifying excel equation

    Does this work for you?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-27-2013
    Location
    Dubai
    MS-Off Ver
    MS365 Version 2301
    Posts
    118

    Re: Simplifying excel equation

    Dear ByteMarks,

    I would like to thank you so much for your help.

    May you please help to add one more condition for the sales in column E is greater than order equal to 4 the result in column F will be 5.
    As when I entrered 4 or more in column E, the equation return #N/A.

  4. #4
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,139

    Re: Simplifying excel equation

    Maybe

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    03-27-2013
    Location
    Dubai
    MS-Off Ver
    MS365 Version 2301
    Posts
    118

    Re: Simplifying excel equation

    I would like to thank you so much for your appreciated efforts and support

    Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 11-21-2023, 02:23 PM
  2. [SOLVED] Simplifying max(if(A=B*C,B ... ) equation.
    By spacely in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 12-07-2016, 09:14 PM
  3. [SOLVED] Simplifying a max(if-then) equation...
    By spacely in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-27-2016, 04:16 PM
  4. Can anyone help with simplifying this super long Excel IF statement?
    By YPerez in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2013, 05:35 PM
  5. Excel 2007 : Help simplifying data entry
    By TNisbet in forum Excel General
    Replies: 1
    Last Post: 07-30-2012, 02:37 PM
  6. excel equation (user defined equation)
    By excel_student in forum Excel General
    Replies: 0
    Last Post: 03-10-2005, 03:59 PM
  7. Help neeeded with simplifying this excel code.
    By J_J in forum Excel General
    Replies: 3
    Last Post: 02-19-2005, 07: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1