Formulas

I just LOVE  formulas I really do, after all they do all the hard work for you!  They can fetch and match data for you based on search criteria, they will calculate values for you based in cells contents, and the great thing is, when you update your data, the results of your formula will change automatically and update based on your new data.

So, once you have a fab formula, it can be used over and over again, how nify is that working smarter rather than harder or what!?!

I have complied a collection of the most commonly used formulas, which will be updated on a regular basis, see below to get started.

[table id=5 /]

Formula Extras

1.Shhhh What Formulas?? How to Hide your hard working formulas and remain the office Guru

2.How to handle ( or Ignore) those annoying formula errors