Hey all.
I'm currently working on an assignment involving the calculation of an optimum. This optimum is based on another value and needs to be rounded accordingly.
In short: We're trying to determine the optimal ordering value. This value is optimal only if the cost of ordering (and storage) is at its lowest point. This value (cost) is based on multiple equations, including one that determines the optimum. The difficulty lies in getting Excel to round either up or down (it is only possible to order an 'integer' amount) based on the cost.
I don't know if I'm making any sense at all, but if I am, please help.
Cheers!
I'm currently working on an assignment involving the calculation of an optimum. This optimum is based on another value and needs to be rounded accordingly.
In short: We're trying to determine the optimal ordering value. This value is optimal only if the cost of ordering (and storage) is at its lowest point. This value (cost) is based on multiple equations, including one that determines the optimum. The difficulty lies in getting Excel to round either up or down (it is only possible to order an 'integer' amount) based on the cost.
I don't know if I'm making any sense at all, but if I am, please help.
Cheers!