Shortcut to Apply a Formula to an Entire Column in Excel
Try double-clicking on the bottom right hand corner of the cell (ie on the box that you would otherwise drag).
excel-formula
Converting time stamps in excel to dates
Use this formula and set formatting to the desired time format: Source: http://www.bajb.net/2010/05/excel-timestamp-to-date/ Tested in libreoffice
Using SUBSTITUTE with wildcard characters
To illustrate my issue, use the following simple example. I want to be able to replace any text that comes between “replace” and “that” to “it is done”. For example, the two following strings: to this string using the SUBSTITUTE function in excel using wildcard characters. This is the formula that I’m using: The formula … Read more
Excel: Can I create a Conditional Formula based on the Color of a Cell?
I’m a beginner and trying to create a formula that modifies the contents of Cell A1 based on the color of the cell in B2; If Cell B2 = [the color red] then display FQS. If Cell B2 = [the color yellow] then display SM. This is conditional based on the cell fill color.
Add a “sort” to a =QUERY statement in Google Spreadsheets
You can use ORDER BY clause to sort data rows by values in columns. Something like If you’d like to order by some columns descending, others ascending, you can add desc/asc, ie:
How to loop in excel without VBA or macros?
The way to get the results of your formula would be to start in a new sheet. In cell A1 put the formula Copy that cell down to row 40 In cell B1 put the formula In cell B2 put the formula Copy that cell down to row 40. The value you want is now … Read more
Declaring variables in Excel Cells
You can name cells. This is done by clicking the Name Box (that thing next to the formula bar which says “A1” for example) and typing a name, such as, “myvar”. Now you can use that name instead of the cell reference:
Is there Infinity in Spreadsheets?
I like to use 1e99 as it gives the largest number with the fewest keystrokes but I believe the absolute maximum is actually 9.99999E+307. At that stage of the number spectrum I don’t think there is much difference as far as Excel is concerned.
What Excel formula returns the sheet name?
Not very good with excel, but I found these here and A1 can be any non-error cell in the sheet.For the full path and name of the sheet, use
Excel to Google Sheets – Error: Formula parse error
There is nothing wrong with the formula in the example. The problem is that it is referring (directly or otherwise) to cells that themselves contain formulae that Google Sheets does not recognise – in particular those containing square brackets.