by admin | Feb 10, 2014 | Excel Formulas | Essential Functions, Excel | General
I recently got asked to help with setting up a formula that would autofill standard entries for particular species. The idea would be that the user would enter a species name and then the other details would fill in as normal. While the example I’ve given here...
by admin | Aug 2, 2012 | Excel Formulas | Essential Functions, Excel | Intermediate Lessons
In a previous blog posting, I showed you how to set up an If statement in Excel. In this blog posting, I am going to show you how to nest an OR function into an IF function (the technique can be used equally well with a NOT, AND, TRUE, FALSE functions). Essentially...
by admin | May 3, 2012 | Excel Formulas | Essential Functions, Excel | Excel Beginner Lessons
Excel min In this post we are going to look at the min function (which finds the lowest value in a list) Facebook Twitter Google+ EmailLinkEmbedCopy and paste this HTML code into your webpage to embed. As always, here is a file you can practise...
by admin | May 2, 2012 | Excel Formulas | Essential Functions, Excel | Excel Beginner Lessons
Excel count text If we want to count the number of names (or list of entries with mixed text and numbers), the count function will not work – simply because it is designed to count NUMBERS only. In this case we have to use the CountA function. See video below...
by admin | May 2, 2012 | Excel Formulas | Essential Functions, Excel | Excel Beginner Lessons
Excel count function This post will show you how to use the Count function. The count function counts the number of items in a list. Unlike the Sum function (which adds up the numbers), the count function tells you HOW MANY NUMBERS in a list. If you want to count the...
by admin | May 2, 2012 | Excel Formulas | Essential Functions, Excel | Excel Beginner Lessons
Average function in Excel (2007/2010) In this post we are going to look at calculating the average in Excel (using the excel average function) Facebook Twitter Google+ EmailLinkEmbedCopy and paste this HTML code into your webpage to embed. As...
