Office
Access 2010 and Access 2007
Last week I use Access 2010 open up a 2007 accdb file, and modify some forms and then save it. One of my colleague tell me that he could not open it using Access 2007. It just said the database format is not matching or something like that. So I search it and find this …
Excel do not display 0 if the cell value is 0
=IF(A2=0,””,SUM(A2:A5))
Quick ways to sum Excel data
> There are a number of ways to insert a SUM() function into an Excel spreadsheet. The hard way is to enter the entire function manually. That method is prone to mistakes because you must know the cell references and then enter them correctly. If you like, you can enter =SUM( manually, highlight the range …
Excel do not display 0 if the cell value is 0
>=IF(A2=0,””,SUM(A2:A5))
不用 install 的 Office
>這幾天去了網吧,發覺原本很多人到網吧做 Document Editing,但是有 D 網吧連 Word and Excel 都冇,這個 web base 的 Office 希望可以幫到手。 Thinkfree or Google Spreadsheet