Hi!
I need some help please! Column L assumes 1 month out on inventory, but what if that formula =J2+(K2/I2)-1 equals zero? If it does equal zero months of inventory on hand at time of next receipt, we'd like for L2 to display the sum less the 1 month (the same number which will populate in J2)=J2+(K2/I2). How can we formulate all of this into a single cell?
thanks!
Hi Valerie,
Your question is difficult to follow without an example file, but you could try an IF formula like this:
=IF((J2+(K2/I2)-1)=0, J2+(K2/I2), J2+(K2/I2)-1) If that doesn't work, then please provide a sample file with your scenario and desired solution.
Mynda
apologies Mynda! I did attempt to upload an example file with my original question. Please find it attached here. The formula you provided should work, but it is giving me a #DIV/0! in the cell.
Thank you for assisting this excel novice!
Hello,
See attached file, column L. I have used the formula that Mynda wrote.
