Top "Formula" questions

A formula is a mathematical equation or expression that performs various operations on variables to produce an outcome.

How do I update a formula with Homebrew?

How do I update a formula? I ran brew update. Then, running brew outdated, outputs: mongodb (1.4.3-x86_64 < 1.6.5-x86_64) Thus, …

homebrew formula
How to find the Center Coordinate of Rectangle?

I have drawn a rectangle. I know its (x1,y1) Top Left and (x2,y2) Bottom Right coordinates.. I also …

math geometry formula
Simulate string split function in Excel formula

I am trying to split a string in an excel formula, something like I can do in many programming languages, …

excel formula excel-formula
How to exclude 0 from MIN formula Excel

i need to know how can i exclude 0 from rows and get the MIN Value. But also i need to …

excel formula min
What is the proof of of (N–1) + (N–2) + (N–3) + ... + 1= N*(N–1)/2

I got this formula from a data structure book in the bubble sort algorithm. I know that we are (n-1) * (…

formula proof
Using relative positions in Excel formulas

How do I create a formula that isn't made invalid when I delete a row. For example in cell F12 …

excel formula
Multiple conditions in Excel conditional formatting

I'm fairly new to Excel and so not very experienced, but I'm trying to get an entire row to highlight …

excel conditional-statements formula conditional-formatting
How can I run VBA code each time a cell gets its value changed by a formula?

How can I run a VBA function each time a cell gets its value changed by a formula? I've managed …

excel vba formula
Any solution to the Today Calculated Column problem is SharePoint?

I would like to be able to use today's date in a calculated column in a SharePoint list to, for …

sharepoint formula
Replacing one character with another in a string

I have a data like below: A:B:C:D and I want to replace the C with data (say, …

excel replace extract formula delimiter