excel training courses uk - solver

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses uk - Solver

excel training courses uk - Solver

resolvedResolved · Low Priority · Version Standard

Krasi has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Solver

How do you restrict data

RE: Solver

Hello Krasi,

Hope you enjoyed your Microsoft Excel Advanced course with BEST Training.

Thank you for your question regarding using the Solver Add-in. When using the solver, you need to specify certain information for the process to work. One of these areas is the CONSTRAINTS area, which will indicate what restrictions the system must use in order to meet your requirements.

To the the contraints, you need two pieces of information - the cell reference and the value you want to constrain to.
Once you have these listed, you can then enter then easily into the constraints section.
Click on ADD.
In the first box, select the cell reference you want to constrain.
Next, choose the operator (Less than, greater than , equal to) in the second box.
Lastly, enter the value that you want to constrain to.

If you want to add further constratins, click on ADD. If not, then click on OK.

Your constraints have been entered, and you can proceed with using the solver to calculate possible scenarios for your model.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer


 

Excel tip:

Removing custom dictionary entries

If you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there.

View all Excel hints and tips


Server loaded in 0.08 secs.