Top "Worksheet-function" questions

A worksheet function is represented by a keyword in an Excel formula that performs some action on input and returns output to the calling procedure, either a worksheet cell or another function.

excel - rounding time to the nearest 15 minutes

I have a formula that computes the difference of several TIMES and multiplies it by 24 to get a decimal value …

excel vba worksheet-function
How can I get a random cell in OpenOffice Calc?

I've perused the Stack Exchange list of sites, and I can only think that SO is the right place to …

formula worksheet-function openoffice-calc
Return if all Excel column values don't agree

I have the following data in an Excel Spreadsheet: A B C 1 b b b I would like to put …

excel excel-2003 worksheet-function
Using built-in spreadsheet functions in a script

I'm using Google App Script for the first time. I'm using it on a Google Doc spreadsheet. I'm trying very …

google-apps-script google-sheets google-sheets-formula worksheet-function
Excel: COUNTIF function treats 'less than' character as an operator

Pre-read note: I'm using LibreOffice rather than Excel, but most functions should apply to both. I'm making a spreadsheet where …

excel worksheet-function libreoffice
Root Mean Square (rms) function in VBA?

So I'm calculating basic statistics in my worksheet and it includes code such as: xxx = Application.worksheetfunction.average(etc etc …

excel vba worksheet-function
How Do You Subtotal with Autofilter in Excel?

I am currently working on an Excel sheet of list of people working in a company. The company has multiple …

excel worksheet-function autofilter
How do I count wildcard characters using Excel COUNTIF?

How do I count the number of cells that contain the string "A*" - without treating the star as a …

excel worksheet-function countif