Poll

Aboot this blog

This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:

feed-icon-28x28.png

DISCLAIMER

Please note that any reviews/recommendations are based solely on my own experience and does not constitute a guarantee that you will have the same experience. Please do your own research before parting with any money - the risk is all yours!

The Briticiser

Looking for my world famous US to GB English spelling converter?

THE “BRITICIZSER”

www.us2uk.eu

IT’S HERE

Tags

  Utilities     Education     Flatpress     Odds and Sods     Bits and Bobs     Family     Bookmarks     VBA     Reviews     Excel     Word     Windows     Software     Plausible Lies     PHP     Tutorials     Equipment         Hardware     Overcoming Disabilities     Acrobat     Browsers     News  

Find me on Facebook

facebook-icon-28x28.pngVisit my Briticiser Facebook Page to keep up with things here - lots of reviews of stuff I’ve really used and also all kinds of helpful computer tips with a heavy bias towards SAVING YOU TIME.

Excel Functions - Version Compatibility

Permalink: http://paul.us2uk.eu/?x=entry:entry161117-162809

While working on a spreadsheet today I was using the ISERROR function to test if a VLOOKUP formula returned a value and, if it did, return the value otherwise display nothing - instead of the usual #N/A error notification.

The usual syntax for this formula begins “=IF(ISERROR(VLOOKUP(…”.

I happened to notice that Excel 2010 (the version I use at work) offered up “IFERROR” as a possible function as soon as I typed the “IF” and, indeed, this allows me to write slightly shorter formula. However this is not backwards compatible with Excel 2003 which I use elsewhere so I avoided using it.

For anyone faced with a situation where they have a spreadsheet containing lots of instances where the a formula contains “IFERROR” then help is at hand at the following link - untested, but I’m sure it’ll work. I’ve bookmarked it here because it looks like quite a useful site.

http://www.professionalexcel.com/2011/06/replace-iferror-with-ifiserror/

There are obviously a few more functions which were added in later versions of Excel which you should avoid using if you don’t want your spreadsheet to fail when someone opens it in Excel 2003 (which I much prefer!). The other one I avoid for this reason is “SUMIFS” (I use “SUMPRODUCT” instead) but here’s a useful list of all Excel functions showing which versions they are compatible with - plus a useful description of each..

https://docs.google.com/spreadsheets/d/1ztUAhgAghKn2wNih7-QgMbSAKfux4w_qkAcJdD82bLU/edit

Here’s the same thing downloaded for posterity as an XLSX file

Fix for Windows 10 Can’t Connect To This Network

Permalink: http://paul.us2uk.eu/?x=entry:entry161025-233719

The solution to this extremely annoying recurring problem which worked for me was this:

[Read More…]

Dad’s Army Story - Victoria Wood

Permalink: http://paul.us2uk.eu/?x=entry:entry160425-005228

Dad’s Army Story

I don’t know Jack

Permalink: http://paul.us2uk.eu/?x=entry:entry160415-143737

David Lynch funded this documentary about the star of possibly the strangest, most intensly photographed film I’ve ever seen.

https://www.youtube.com/watch?v=-cSZvOyZNtU

A documentary about Jack Nance, star of the David Lynch film “Eraserhead”

Encephawhat?

Encephalitis - it really sucks.

Georgi says Hi!

If you found anything on this site of use, interesting, or even mildly amusing please consider tipping a few pennies in the jar to help look after Georgi, to whom this blog is shamelessly dedicated.

Georgi contracted encephalitis and fell into a coma in the summer of 2007. He’s a strong boy and survived, but he suffered brain damage and still can’t walk or talk (well, not very well - but he does try). He’s growing all the time and every penny we collect goes towards his upkeep, and towards his future care requirements.

visit Georgi’s blog
http://blog.georgi.co.uk/