“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hello, I am looking for an inventory formula where one column states my max then next states how many I have available and the last is how many I need to order. I would like for the "available" column automatically transfer the amount I need in the reorder column. For example, if I say I need a max of 10 in stock but I only have 4 available I would like for the reorder column to automatically change to 6.

Solved by G. Q. in 28 mins

I keep trying inputting in a formula in my excel spreadsheet and it keeps just putting the word "reorder" in the cell. please let me know what I am doing wrong.

Solved by O. B. in 11 mins

But if the value is false, nest a second nested IF and AND function in which the logical test determines if the Discontinue in K19 is equal to "N" and the Current Inventory is less than or equal to the rush reorder point in J19. If the value is true, "Rush" should be returned. If the value is false, then nest a third IF and AND function in which the logical test determines if Discontinue (K19) is equal to "N" and Current Inventory (H19) is less than the Reorder Point (I19). If the value is true, return "Reorder". If the value is false, return "Ok".

Solved by D. B. in 22 mins

I created a survey on One Drive online through Excel. When I edit the survey, the excel document column order does not change. How can I reorder the excel document without affecting the data and actual survey order?

Solved by C. F. in 25 mins

Hi, I am trying to make an inventory list that once a reorder level threshold is met it will give me the total needing to be reorder from my quantity to keep on hand. Can someone please help me with the formula that will calculate this? Thanks

Solved by Z. Y. in 30 mins