Top "Formula" questions

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

How to turn a string formula into a "real" formula

I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and …

string excel formula evaluate
Fill formula down till last row in column

I'm trying to draw down the formula that's in cell M3 to the end of the data set. I'm using …

excel vba formula
Using OR & AND in COUNTIFS

I would like to include an "AND" condition for one of the conditions I have in my COUNTIFS clause. Something …

excel formula conditional-statements
Base64 length calculation?

After reading the base64 wiki ... I'm trying to figure out how's the formula working : Given a string with length of …

string base64 padding formula
Determine if a cell (value) is used in any formula

I am trying to reverse engineer an ancient program written using VBA in excel and formulas in cells. There are …

excel formula
Formula px to dp, dp to px android

I am trying to calculate a variable amount of pixels to density independent pixels and vice-versa. This formula (px to …

android formula density-independent-pixel
Calculate percentage saved between two numbers?

I have two numbers, the first, is the original price, the second, is the discounted price. I need to work …

math formula
VBA setting the formula for a cell

I'm trying to set the formula for a cell using a (dynamically created) sheet name and a fixed cell address. …

excel vba cell formula
How to utilize date add function in Google spreadsheet?

I believe the issue I am having now should be much easier in MS Excel. However, since my company uses …

google-sheets formula
How do I count cells that are between two numbers in Excel?

I need a formula to count the number of cells in a range that are between 10 and 10.000: I have: =COUNTIF(…

excel range formula