To access the 'Report Manager' (also listed as an 'Add-Ins' item) select the 'View, Report Manager.' menu item. These features are available via the 'Tools, Wizard, Lookup.' and 'Tools, Wizard, Conditional Sum.' respective sub menu items, and not via the 'Add-Ins' window's list. The same applies for the 'Lookup Wizard' and 'Conditional Sum Wizard' 'Add-Ins' items. I know, the above contradicts what 'Excel's Help, Excel Help' menu item's 'Microsoft Office Help window displays - when a search for 'Solver tool' is made, and the 'Add-in programs for Microsoft Excel' link (the last one) is selected. If not installed - navigate though the same folders on the 'Microsoft Office 2004' installation CD and drag them over to the hard disk drive based 'Microsoft Office 2004' 'Add-Ins' folder. After that, press the enter key to calculate the logarithm. Next, you need to type LN( into the cell and then click on the cell with the number you want to calculate the logarithm of.

'/Microsoft Office 2004/Office/Add-Ins/').ĭo you see the files 'Solver Library' and 'Solver.xla' in the 'Add-Ins' folder? If so, you have the 'Solver' tool installed - even though it is not displayed in the 'Add-Ins' window's list (obtained via 'Excel's 'Tools, 'Add-Ins.' menu item). To use the LN function in Excel, you first need to enter the number you want to calculate the logarithm of into a cell. Click Load/Save, enter a cell range for the model area, and then click either Save or Load. Locate and open the 'Office' folder, and then it's 'Add-Ins' folder (. In Excel for Mac 2011: Click the Data tab, under Analysis, click Solver. Locate and open the 'Microsoft Office 2004' folder (an assumption on my part, since you made no mention of the version of MS Office / Excel you are referring to). If you did indeed select the 'Tools, Solver.' menu item and no 'Solver Parameters' window appears.

I am assuming here - that you did not notice this. To access the 'Solver' tool just select 'Excel's 'Tools, Solver.' menu item.

How to add solver in excel mac