xlsref Tag Posts Index

Tonight I discovered something sneaky about the SUM() in Excel

It may be this way in programs which are compatible with Excel as well. The thing is that this was done deliberately. For a function as widely known as SUM(), who

Hot off the press at LeoFinance

An XLSref Investigation: Testing Excel's VAR()

An XLSref Investigation: Testing Excel's VAR()

How can 5 numbers less than 100 lead to a sample variance over 1000? Is Excel 2003's VAR() bugged? XLSref investigates. Images are edited screen captures from either

Hot off the press at LeoFinance

An XLSref Investigation: Testing Excel's DB()

An XLSref Investigation: Testing Excel's DB()

Did Excel 2003's DB() function have a bug? Who knows? That's why I investigated this for XLSRef (powered by LeoThreads). Images are edited screen captures from either

I've been occupied at LeoThreads with a spreadsheet project--

XLSref is a reference for functions, concepts, UI elements, and other content useful for spreadsheet users of all levels. The idea is to make the reference available