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) Please enable JavaScript LinkEmbedCopy and paste this HTML code into your webpage to embed. As always, here is a file you can practise with ...
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) Please enable JavaScript LinkEmbedCopy and paste this HTML code into your webpage to embed. As always...