=IF(ISBLANK(C9) '' IF(E9>B9 (C$5*0.5*E9*C9)+(C$4*C$6/E9)+(C$6*C9) (C$5*0.The solution to storing all your numbers and lists!Ĭalc is the spreadsheet application you’ve always wanted. Then just copy it (CTRL+C), and paste it (CTRL+V) into your spreadsheet. Just triple-click on the formula and it should highlight. The table below references the page number and figure number from the book, and the spreadsheet Cell Reference where the formula would be entered. It is only some of the longer ones or ones with special characters where a simple typo could cause you some serious aggravation.

This is NOT all of the formulas from the book. These formulas have been adapted to the Calc Spreadsheet Program. Here is a 'cheater page' for some of the longer and more complicated formulas. Also, Calc may return different week numbers than Excel. So instead of the Excel formula =WEEKDAY(A3) you would enter =WEEKDAY(A3 1). You need to enter the “Mode” that sets the start day of the week.

WEEKNUM function works a little different than in Excel.

Version 3.0 Calc does have a Solver add-in, but it is more limited than the one in Excel and I could not get it to work with the examples in this book.

However it does have the Forecast function which works the same as Excel (using semicolons instead of commas).

I could not find a Regression Tool in Calc similar to Excel's, so you won't be able to do the regression example.

Basically, wherever you would use a comma in an Excel function, you would instead use a semicolon in Calc.

All the basic formulas work pretty much the same as in Excel, however, functions that require arguments have a slightly different syntax.

I tested most of the examples from the book in Version 3.0, and have put together some notes on what works, what doesn't, and what works a little differently. These software suites have come a long way in recent years and though not yet quite as functional as Microsoft Office, they are pretty damn close. Both programs are open-source free products.

If you don't have access to Microsoft Excel, you can do most of the calculations from the book using either Calc Spreadsheet Program or LibreOffice Calc Program.

Openoffice calc sum not working