I have a stock control sheet i'm struggling with. I've got four columns where all the work needs to be done. As set out below,
No in Stock Reorder Level Reorder Quantity Stock Orders
2 30 10
58 55 80
4 45 10
34 28 50
So basically i need to fill in the Stock Orders column cells with either Re-order or Too Many, So taking the first cell from my sheet, No in Stock is 2 so its below the reorder level and so Stock Orders cell needs to show Re-order and then the next No in stock is 58 but re-order level is 55 so Too many. I've tried a few things but to no avail, this is my last try so far and it came up re-order....=IF(E2<=G2,"Re-order",IF(E2>=G2,"Too Many,"))
Any help please?
No in Stock Reorder Level Reorder Quantity Stock Orders
2 30 10
58 55 80
4 45 10
34 28 50
So basically i need to fill in the Stock Orders column cells with either Re-order or Too Many, So taking the first cell from my sheet, No in Stock is 2 so its below the reorder level and so Stock Orders cell needs to show Re-order and then the next No in stock is 58 but re-order level is 55 so Too many. I've tried a few things but to no avail, this is my last try so far and it came up re-order....=IF(E2<=G2,"Re-order",IF(E2>=G2,"Too Many,"))
Any help please?