Forum Discussion
Conditional Quantity formula help please
Hi folks, arranging a parts list on excel, some components have a "minimum order" of say, 5 units. I would like to enter that I want "Required" 7, and the actual "quantity order" cell automatically ...
I think I did it!
| Req. per Enc Mod | Total Required | Min Order | Multiple | Left over |
| 1 | 1 | 1 | 1 | 1 |
| 8 | 8 | 1 | 8 | 1 |
| 6 | 6 | 5 | 1.2 | 10 |
Final column has formula =IF(J7<=1,(I7),(ROUNDUP(J7,0)*(I7)))