rajesh2022
New Member
I am looking to update Stock value using Excel Formulas.
Here is the scenario.
I have 4 columns: Products, Minimum Stock, Current Stock, and Required Stock. I need the Required Stock columns to be updated using the formula.
Basically it has to check whether Current Stock is equal to or more than Minimum Stock. If it matches then we can update it as "0" else We need to add the Minimum Stock value to Current Stock to see if it's more than the minimum stock, if still not matches then we need to multiply and check if it's more than Minimum Stock.
I need Required Stock column has to be updated with Formula
Eg:
Here is the scenario.
I have 4 columns: Products, Minimum Stock, Current Stock, and Required Stock. I need the Required Stock columns to be updated using the formula.
Basically it has to check whether Current Stock is equal to or more than Minimum Stock. If it matches then we can update it as "0" else We need to add the Minimum Stock value to Current Stock to see if it's more than the minimum stock, if still not matches then we need to multiply and check if it's more than Minimum Stock.
I need Required Stock column has to be updated with Formula
Eg:
