Tag Archives: Switch function

Daily Download 33: Miscellaneous

Posted on 21/10/2012 by dougaj4

This is the last of the month and a bit of Daily Downloads, and consists of a bumper bundle of 20 spreadsheets with miscellaneous functions that didn’t fit in elsewhere: Repeating a set of data: for instance making three copies of … Continue reading →

Posted in Arrays, Computing - general, Excel, UDFs, VBA | Tagged Code generator, Comparing floating point values, Excel, Match Function, scripting dictionaries, Sort Function, Switch function, UDF, Using Goal-seek, VBA | Leave a comment

The Switch Function (VBA and UDF)

Posted on 27/01/2012 by dougaj4

Switch is a VBA function that operates in a similar way to the Select Case statement. The function arguments are a series of pairs of values, the first of each pair being an expression that can be evaluated as TRUE … Continue reading →

Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged Excel, PY curves, Switch function, UDF, VBA | 9 Comments

	Cleaning Data… on New sort functions and sorting…
	AS 3600 public comme… on py_RC Design 2
	dougaj4 on py_RC Design with 3D Cach…
	doug marcus on py_RC Design with 3D Cach…
	Enrique on DigitGraph Spreadsheet and Web…
	py_RC Design with 3D… on py_RC Design 2
	py_RC Design with 3D… on Passing 3D arrays to Excel wit…
	Z on Solving polynomials –…
	dougaj4 on Solving polynomials –…
	VBA polynomial funct… on Calling Numpy polynomial funct…
	VBA polynomial funct… on Solving higher order poly…
	VBA polynomial funct… on Complex Numbers and Solving Qu…
	VBA polynomial funct… on Solving polynomials –…
	Z on Solving polynomials –…
	dougaj4 on Solving polynomials –…

Tag Archives: Switch function

Daily Download 33: Miscellaneous

The Switch Function (VBA and UDF)

Categories

RSS Feed

Search NewtonExcelBach

Archives

Top Posts

Recent Comments

Blogroll

Family Links