Formula to calculate column values as based IF/And function

[Pankaj jaswani]

Hello,

I am trying to match the calculation of column values through IF/And/Or function but unable to extract the same by formulas even I am using another column helper but the result is not getting the same as I want. Please help me to calculate the exact values. Thank you in advance.

[PaulM100]

No explanations whatsoever in your file. Provide the logic behind your expected formula

[Pankaj jaswani]

No explanations whatsoever in your file. Provide the logic behind your expected formula

In Column E is the Sellout Qty of Last 4 Weeks, I have to calculate the suggested order based on Sellout Qty. Below are the criteria to calculate the suggested order.




1) SKU should available [Column F] is 12 days of stock based on the last 28 days sellout ( Last4Weeks sellout)
2) If Sellout Qty is Zero then Column F will be minimum 1 Qty.
3) If Column F is more than the stock norms (Column D) than the Suggested Order (SO) will not be more than Stock norms.
4) If Column F is less than the stock norms then the SO will be (SKU should available - Closing Stock).

[Pepe Le Mokko]

FYI I have no idea what SKU means... Don't expect everyone to understand your technical jargon. Thanks

[Pankaj jaswani]

SKU means Stock Keeping Unit and everyone knows it bro.!

[Pepe Le Mokko]

SKU means Stock Keeping Unit and everyone knows it bro.!

I'm sorry but I don't and why should I ? Please show some courtesy to those willing to help
I also don't like being called "bro" by persons I don't know

[Pankaj jaswani]

Okay thanks..

[PaulM100]

2nd and 3rd rows contain the exact same values in columns D and F, but you have 1 and 0 in H. Makes no sense right now.

[Pankaj jaswani]

2nd and 3rd rows contain the exact same values in columns D and F, but you have 1 and 0 in H. Makes no sense right now.

Bro Column D is for Stock Norms and Column F is for SKU should available (which is calculated based on Sellout/28*12) and in H column is suggested order this value is calculated based on the portal but I want to extract this value by a formula with the mentioned criteria.

[PaulM100]

You still didn't answer my question. You don't need to explain me the logic behind each column. You need to explain the logic on how to arrive at the desired results when you have the same values, but different results.

1) SKU should available [Column F] is 12 days of stock based on the last 28 days sellout ( Last4Weeks sellout)
2) If Sellout Qty is Zero then Column F will be minimum 1 Qty.
3) If Column F is more than the stock norms (Column D) than the Suggested Order (SO) will not be more than Stock norms.
4) If Column F is less than the stock norms then the SO will be (SKU should available - Closing Stock).

Formula for this would be =IF(F4>D4,0,IF(F4<D4,G4)) which is incomplete

[Pankaj jaswani]

You still didn't answer my question. You don't need to explain me the logic behind each column. You need to explain the logic on how to arrive at the desired results when you have the same values, but different results.

Formula for this would be =IF(F4>D4,0,IF(F4<D4,G4)) which is incomplete

Actually the desired result is exported from site, but i have no access to get this type of report from now. But i want to calculate this result manually by formula.

[Pankaj jaswani]

This type of calculation will be on a daily basis, I have to calculate daily suggested order based sellout qty and criteria. And I am trying to match the same result by a formula but unable to track with my formulas. That is why I am asking for help from you guys.

[PaulM100]

There is no logic that can be understood in the file. If you find out the rules, then we could set up a formula.