answersLogoWhite

0

Use the Solver tool. See related links for an example.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Is there a connection between the Sharpe optimal ratio and the CAPM?

The portfolio with the highest Sharpe ratio is on the efficient frontier, according CAPM. The Excel spreadsheet at the related link allows you to calculate a Sharpe optimal portfolio


Is font size measured in Excel inches centimetres or pixels or points?

It is measured in points.


Why do you use MS Excel?

Many people use Microsoft Excel to perform calculations. They also use it to establish databases for their business. Excel makes people efficient.


Why do pharmacy technicians use Microsoft Excel?

Pharmacy technicians use Microsoft Excel because it is a fast and efficient means of organizing data.


What is the format symble in Excel?

All depending on what version of Microsoft Excel you have - there's a tab along the top toolbar that says "Format".


What is the maximum number of data points that can be graphed in an Excel line chart?

In Excel, the maximum number of data points that can be graphed in a line chart is 32,000 for Excel 2007 and later versions. This limit applies to the total number of data points across all series in the chart. However, for practical purposes, performance may degrade with very large datasets, so it's often advisable to use fewer data points for clarity and readability.


Excel components that can be used to make your work more efficient worksheets more professional?

Office Button


What is XY chart in Excel?

It is a chart for plotting points and can also be used to chart lines and curves.


Which Excel function would be used to calculate the total points a student earned on a series of tests?

sum


Where will the 2012 Judo be held?

ExCeL London ... aka Exhibition Centre London. Along with judo ... boxing, table tennis, taekwondo, wrestling, weightlifting, and fencing will be held at ExCeL London.


What key do you use as a purge key if you have 22000 points of information and you want to purge down to about 400 or 500 points at random interfalls using excel?

Get A copy that is $40 to get purge and mewthree


How can I import test cases from Excel to Jira?

To import test cases from Excel to Jira, you can use the Jira Importer tool or third-party plugins like Xray for Jira. These tools allow you to map the Excel columns to Jira fields and easily transfer the test cases into Jira for efficient test management.