Top "Formula" questions

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

Excel - Conditional Formatting - Cell not blank and equals 0

I'm trying to check if a cell is: blank, and if false (not blank) If value equals 0. I have tried: =…

excel formatting conditional formula
Excel: Scalar product of two ranges

I am trying to find a proper way to calculate the scalar product of two ranges. For instance, the product …

excel formula scalar
Excel: Change multiple formulae at once?

I've sorted a chunk of data into sub-totaled fields using the Subtotal tool under the Data tab. However, you are …

excel formula
Returning cell values from other sheets by referencing sheet names from a list

I have a spreadsheet with approx twenty different sheets named by stock ticker. Because these are templates, the information in …

excel excel-formula formula worksheet-function excel-indirect
How to render Latex markup using Python?

How to show an easy latex-formula in python? Maybe numpy is the right choice? EDIT: I have python code like: …

python latex formula
short formula call for many variables when building a model

I am trying to build a regression model with lm(...). My dataset has lots of features(>50). I do not …

r formula
How to extract URL from Link in Google Sheets using a formula?

I have copied from a website a series of hyperlinks and pasted them in a google sheet. The values show …

google-sheets formula
How to use reference variables by character string in a formula?

In the minimal example below, I am trying to use the values of a character string vars in a regression …

r string formula paste names
Padding a fixed number with leading zeros up to a fixed length

In Crystal Report using Visual Studio 2010, I am trying a to create a formula for the following scenario: x = any …

crystal-reports report padding formula zero
Math on batch (win)

I am developing a CMD batch. I want to do some math in it. This formula: (x+1)100:y So in …

math windows-7 batch-file cmd formula