If Countif IfAndOr VLookup


My Favourite Functions in Spreadsheets

There are actually some useful functions for everyday use in a spreadsheet. Nothing fancy like solvers or pivot tables. Simple functions that can make everyday work easier. For everyday tasks.
I can only speak for Microsoft Excel - but I'm sure almost every calculation program has these functions in a similar way.

Everything listed via the four links in the Navigation Bar is based on spreadsheets not using the R1C1 reference style. In the unlikely event of being interested in this hilarious subject, there's a downloadable zip-file with more examples listed below.

The Examples file should display all functions in the respective language of the MS Excel version used.

Save Excel file with examples (*hqx) 
Save Excel file with examples (*zip)

This page has been visited...   

Solve It

June.2002 / Text and examples last changed 24.Jan.2000
A. Parkhouse / Mail / back to Artoo.de / Guestbook

PDF File  These pages are available as print-friendly PDF (click icon). Get Acrobat Reader