in excel solver or primum solver, how do u set it up so it will suggest only whole numbers?

Question

i'm workin on this poblem where solver suggest 7.3 trucks! of course its a truck so i cant have fraction, how do i set it up to suggest only whole numbers? i have solver and premium solver

Answer 1

Because you still need a partial truck load delivered, you want to use "roundup" so that it will be rounded up to the nearest truck. If the answer is in A1, then use:

=ROUNDUP(A1,0)

The 0 tells it to round up to the nearest whole number.

Answer 2

I don't think solver can do integer. They think in 1 and a half man , that is how they can solve the problems you give em. You decide to hire 2 or 1 man based on your final judgement.

Answer 3

Hi,

You need the round function.

Syntax

ROUND(number,num_digits)

Number is the number you want to round.

Num_digits specifies the number of digits to which you want to round number.

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
If num_digits is 0, then number is rounded to the nearest integer.
If num_digits is less than 0, then number is rounded to the left of the decimal point.
Example

The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

Create a blank workbook or worksheet.
Select the example in the Help topic.
Note Do not select the row or column headers.



Selecting an example from Help

Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1
2
3
4
5
A B
Formula Description (Result)
=ROUND(2.15, 1) Rounds 2.15 to one decimal place (2.2)
=ROUND(2.149, 1) Rounds 2.149 to one decimal place (2.1)
=ROUND(-1.475, 2) Rounds -1.475 to two decimal places (-1.48)
=ROUND(21.5, -1) Rounds 21.5 to one decimal place to the left of the decimal point (20)

Norm