Tag Archives: IEE 754

Floating Point Precision Problems

Posted on 05/04/2021 by dougaj4

A question on Quora : prompted me to look at how these numbers are handled in Excel, in VBA called from Excel, and in Python called from Excel via pyxll. The results are shown in the screenshot below: Column A … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged Excel, Floating point arithmatic, IEE 754, Numpy, Python, PyXLL, UDFs, VBA | 1 Comment

When does 35 not equal 35?

Posted on 20/12/2011 by dougaj4

… and when does 35 – 35 not equal zero? In the first case the answer is when one “35” is on an Excel spreadsheet and the other 35 is in VBA. The question arose from the ongoing continuous beam … Continue reading →

Posted in Excel, Maths, Newton, VBA | Tagged Excel, Floating point arithmatic, IEE 754, VBA | 12 Comments

	py_ConBeamU and Stra… on py_ConBeamU
	py_ConBeamU and Stra… on ConBeamU and Strand7 check…
	ConBeamU and Strand7… on Using ConbeamU
	ConBeamU and Strand7… on ConBeamU 4.08…
	dougaj4 on The TrimRange Function
	khoitsma on The TrimRange Function
	py_UMom 1-05 \| Newto… on py_UMom 1.04
	py_UMom 1.04 \| Newto… on py_UMom spreadsheet and OptShe…
	Mandelbrot, Mojo, Nu… on Computing and plotting the Man…
	py_Numpy update 2: P… on Numpy where and split, and py_…
	Numpy where and spli… on Scipy functions with Excel and…
	py_RC Elastic 1.05 w… on Elastic Biaxial Bending
	py_RC Elastic 1.05 w… on py_RC Elastic 1.04 and fatigue…
	ConBeamU update \| Ne… on Using ConbeamU
	dougaj4 on Using ConbeamU

Tag Archives: IEE 754

Floating Point Precision Problems

When does 35 not equal 35?

Categories

RSS Feed

Search NewtonExcelBach

Archives

Top Posts

Recent Comments

Blogroll

Family Links