Top "Formula" questions

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

Formula with dynamic number of variables

Suppose, there is some data.frame foo_data_frame and one wants to find regression of the target column Y …

r formula
How to count cells that only contain the VALUE 0 and not the result of a formula?

For the following sheet: A 1 0 2 0 as formula result 3 0 4 0 as formula result 5 0 as formula result 6 blank 7 0 How do I count only …

excel excel-formula formula countif
In R formulas, why do I have to use the I() function on power terms, like y ~ I(x^3)

I'm trying to get my head around the use of the tilde operator, and associated functions. My 1st question is …

r formula polynomials tilde
Converting number to words in Crystal Reports

How can you convert a number to its written-equivalent in a formula? For example, 10000 is converted to Ten Thousand.

crystal-reports formula
Calculating mortgage interest in Python

I am currently learning python through a video tutorial on youtube, and have come up against a formula I cannot …

python python-3.x formula calculator
Typesetting LaTeX fraction terms to be larger in an equation

I have the following formula in LaTeX, based on Fisher's Exact Test. (NOTE: requires the use of the amsmath package …

latex formula equation mathematical-typesetting
Error in terms.formula(formula) : '.' in formula and no 'data' argument

I'm tring to use neuralnet for prediction. Create some X: x <- cbind(seq(1, 50, 1), seq(51, 100, 1)) Create Y: y <…

r formula prediction
How to use a named column in Excel formulas

I know how to make a named range in Excel. I have a spreadsheet, with various columns going across as …

excel range formula named
Calculate Height for Image/Video based on Aspect Ratio and Width

I have a width: 240 I have aspect ratio: 2.40 I need to get the height based on those two variables. What's …

formula aspect-ratio
Create in-cell dropdown with filtered range

I'm using Google Spreadsheet. To illustrate my problem, I use the range A2:A8 for the data validation of D2 …

google-sheets formula spreadsheet