# Simplifying excel equation

1. ## 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.

2. ## Re: Simplifying excel equation

Does this work for you?

Formula:
`Please Login or Register  to view this content.`

3. ## 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. ## Re: Simplifying excel equation

Maybe

Formula:
`Please Login or Register  to view this content.`

5. ## Re: Simplifying excel equation

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

Solved.

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

#### 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