How to open .chm file on Mac OS X
I downloaded an ebook from a web site. But the file extension of the ebook is in .CHM format. I cannot open it on Preview.
According to Wikipedia, .chm is a filetype devised by Microsoft which compresses HTML files into a single document, usually for the purpose of software manuals. Nowadays, most of the ebook are in PDF and CHM format. We can read the CHM files in Windows, but how about Mac OS X?
I did some research on Google. I found that there are 2 open source software which allow me to open the .CHM files. Below are the software that i going to share with all of you.
Excel 2007 -How to get the smallest value from a set of values without sorting out the data.
In the previous post, i have show how to use “SUMIF” function. I will continue use the table from previous post to show how to use SMALL function in Microsoft Excel 2007.
Normally, we are using “SORT” function to get the smallest or largest records. However, by using “SMALL” function, we do not need to do it so. Read more
Excel 2007 – How to get the SUM value in Multiple Criteria
How do I get to sum the values in a range that meet criteria that you specify?
We can use SUMIF() formula to do that. Besides, we also can use SUMIF() worksheet function for the following situations:
- When you want to return a sum for a single criteria (for example, a single IF condition)
- When you want to use multiple criteria and return the sum to multiple cells
Syntax:
SUMIF(range, criteria, [sum_range])
