#worksheet-function

Answer: Leading zeros in google spreadsheet automatically removed #dev #it #answer

Leading zeros in google spreadsheet automatically removed

I have a column in which all inputs are numbers. But these numbers are actually not real numbers. Not real in the sense, 050 in this case is very different from 50

The problem is that whenever I add 050 the sheet automatically turns it to 50. I have also tried ** 050**. That is, prepending a space to no avail. It still auto-corrects as 50.

How to: Are Excel formulas and Google Spreadsheet formulas the same? #programming #dev #solution

Are Excel formulas and Google Spreadsheet formulas the same?

I want to be sure all my Google Spreadsheet work can be converted OK to Excel. How many of the Excel formulas match the formulas of Google spreadsheets?

Answer [by Mohan Gajula]: Are Excel formulas and Google Spreadsheet formulas the same?

Almost all formulas are same in Microsoft Excel and Google Spreadsheet.

There are both pros and…

Answer: In Google Spreadsheets how do I select column 1's value if an input value is between the integers in colums 2 and 3 for a range? #fix #development #answer

In Google Spreadsheets how do I select column 1’s value if an input value is between the integers in colums 2 and 3 for a range?

In a Google Docs spreadsheet I have two tables:

Date BMI BMI Outcome 2011-06-21 22.1 ? 2011-06-22 21.8 ? 2011-06-23 21.5 ?

and

Name From To Severely underweight 15.99 Underweight 16 18.49 Normal 18.5 24.99 Overweight 25 29.99 Obese Class I 30 34.99 Obese Class II 35…

Solution: Using INDIRECT() in sheet reference range #answer #development #programming

Using INDIRECT() in sheet reference range

I have a separate sheet with some data where a user’s input will reference the row number of a sheet. I’m trying to reference that sheet by inserting the column letter and taking a number input from a cell to make up the row #.

I’ve tried:

=Sheet2!INDIRECT(“A”&A1)

where A1 in the current sheet holds a value of 2, thus I want it to obtain

=Sheet2!A2

T…

How-to: Sum of all cells in Google Spreadsheet where matching row fits a value #it #development #solution

Sum of all cells in Google Spreadsheet where matching row fits a value

I want to return the sum of all cells in ColumnA only if the value of a cell on the same row is equal to a specific value.

For example, sum C4 if D4 = “Bob”. Assuming there are six rows whereby “Bob” appears in ColumnD, I would expect that the sum of six values from ColumnC would be added together.

My suspicion is the above…

Answer: What is a formula to remove the whitespace from an Excel cell when trim doesn't work? #it #programming #fix

What is a formula to remove the whitespace from an Excel cell when trim doesn’t work?

I have a table of Excel data that I copied from an html table in Internet Explorer. A column of table values all seem to have a space at the end of them, but Trim won’t remove it. When I paste-special the value of the result of the Trim function, it still has the whitespace on the end.

Could it be some other…

Answer: allow two possible values in a Excel cell #computers #programming #fix

allow two possible values in a Excel cell

I would like to create a cell format for one cell to only allow the value “yes” or “no” for this cell.

How could I do this?

Answer [by dcp]: allow two possible values in a Excel cell

Click cell you want to restrict value for.

Go to Data->Validation

On the dialog that comes up, for Allow, select List, and for Source, put in “Yes,No”.

Now your cell will…

Fixed: Google Spreadsheet conditional counting function #answer #solution #programming

Google Spreadsheet conditional counting function

I am having trouble writing a function for this need (in Google spreadsheets):

I have 2 columns A and B.

I want to be able to get a percentage based on those two columns. I want to count the number of times a specific value is found in A and only if B has a certain value in it.

Example:

A B name1 yes name2 no name7 no name1 yes name1 no name2 yes