Spreadsheetformula - spreadsheetformula.com - Spreadsheet Formula
General Information:
Latest News:
Excel RANGE 25 Jan 2011 | 02:19 am
To create a spreadsheet formula you need to use an Excel function unless it is a very simple adding and subtracting type of formula. Once you know which function to use you then need to follow the rul...
Excel COUNTIF 22 Jan 2011 | 01:00 am
Spreadsheets contain millions of cells ready to be filled with your data. The problem is who would want to fill in all those cells and have to keep track of them. Fortunately there are functions that ...
IS Function 20 Jan 2011 | 02:16 am
There are hundreds of functions built into spreadsheets which users will need to create good formulas. In Excel each one is grouped into a category that’s relative to the category name. One group, cal...
DATE, TIME Functions 10 Jan 2011 | 01:34 am
As you know we live in a world where nations decide on how the date should be written rather than agree on one format. This has created dates in a different format from one contry to the next. In nume...
Rounding Numbers 17 Dec 2010 | 02:20 am
The final figure from calculating mathematical formulas can end up with many digits after the decimal point. If the cell that contains the figure isn’t wide enough to fit all the digits, then it will ...
Expenses Spreadsheet 11 Dec 2010 | 03:21 am
Many people do not know what their total expenses are each month and often wonder where all their money goes. Keeping track of expenses can help spenders identify problem areas and then rectify them w...
Excel Concatenate 1 Dec 2010 | 01:00 pm
In a job interview I had many years ago the interviewer asked if I knew how to use the formula in Excel, CONCATENATE. Luckily I did and so now I’ll show you how easy the CONCATENATE Worksheet Function...
Excel Function 29 Nov 2010 | 12:53 am
To create a spreadsheet formula you need to know which Excel function to use. Excel’s ability to take on almost any task comes from it’s massive list of worksheet functions. There are hundreds of choo...
PV Worksheet Function 20 Nov 2010 | 02:19 am
Excel is a great tool for simple formulas but for the more complex calculations, well that’s when it really get’s exciting. Because we live in a monetary society it is vital that we understand the sys...
Excel COUNT 13 Nov 2010 | 02:45 am
In every Excel spreadsheet there is the possibility that a user could fill in every cell with data. For the older versions that would exceed 16 million cells and for the 2007 version you’re looking at...
