About 1,134,240 results (3,563 milliseconds)
I need to make a formula in Excel that takes a symbol and makes it ...
https://support.google.com/docs/thread/148132816/i-need-to-make-a-formula-in-excel-that-takes-a-symbol-and-makes-it-equal-to-amount-and-double-it?hl=en Jan 27, 2022 ... I need to make a formula in Excel to do the following: I put in an a number in the cell and then it automatically mulplies by the value I need.
Can I prevent down-fill from incrementing *every* cell reference in a ...
https://support.google.com/docs/thread/5225132/can-i-prevent-down-fill-from-incrementing-every-cell-reference-in-a-formula?hl=en Apr 30, 2019 ... When I add new rows I use down-fill to create the formula cell at the end of each row. ... Microsoft Excel and I guess there is a lot of overlap.
Formula and Converting text into numbers - Google Docs Editors ...
https://support.google.com/docs/thread/38782238/formula-and-converting-text-into-numbers?hl=en Apr 8, 2020 ... I am wondering if there is a formula that I can use to have the pull down menu in my sheets in cell BC to convert these items into a number.
How to get only the number from a cell in a formula - Google Docs ...
https://support.google.com/docs/thread/156228858/how-to-get-only-the-number-from-a-cell-in-a-formula?hl=en Mar 21, 2022 ... I want $A$1 in formulas in other cells to have the number 5, not the string "Team size 5". Is this done with Format->Number->Custom ...? Or is the solution to ...
I cannot get Google Sheets to autofill a column with sequential ...
https://support.google.com/docs/thread/206551466/i-cannot-get-google-sheets-to-autofill-a-column-with-sequential-numbering?hl=en Mar 17, 2023 ... Here are two formulas that will create a list of sequential numbers from 1 to 100... =SEQUENCE(100,1,1,1).... this will work in any cell in the ...
How do I make one cell 20% of another cell's number? The other ...
https://support.google.com/docs/thread/72851853/how-do-i-make-one-cell-20-of-another-cell-s-number-the-other-cell-is-a-sum-of-the-cells-above-it?hl=en Sep 23, 2020 ... The other cell is a Sum of the cells above it. I am new to sheets and not familiar with the formulas needed to calculate a percentage of another ...
Converting a choice from a drop down menu in a cell to a number in ...
https://support.google.com/docs/thread/38765918/converting-a-choice-from-a-drop-down-menu-in-a-cell-to-a-number-in-sheets-to-be-totaled?hl=en Apr 8, 2020 ... I know how to do the SUM formula to total cells if the are displaying numbers, but I don't know how to have the values convert to a number once ...
how to return a zero when a number is negative - Google Docs ...
https://support.google.com/docs/thread/19885345/how-to-return-a-zero-when-a-number-is-negative?hl=en Nov 14, 2019 ... I have this formula which at times, based on what's in C8, will return a negative number. How can I make these instances of negative returns ...
Copy paste a formula, only change 1 of the several references ...
https://support.google.com/docs/thread/132671332/copy-paste-a-formula-only-change-1-of-the-several-references?hl=en Oct 27, 2021 ... Does anyone know a way to copy paste the formula with only the cell S2 increasing everytime it is pasted under each other, so the other numbers ...
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Functions can be used to create formulas that manipulate data and calculate strings and numbers. Here's a list of all the functions available in each category.
How to reference cells value and not it's formula - Google Docs ...
https://support.google.com/docs/thread/6274141/how-to-reference-cells-value-and-not-it-s-formula?hl=en May 16, 2019 ... I then have another cell that is using the IFS formula to see if the above cell equals a certain number. So if the cell above = 9 then this cell ...
How to save random numbers?
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/WuTy0uHh6MM Jan 5, 2012 ... > way to make a function or formula that summates the generated > random numbers everytime the number is regenerated? > For example: when ...
Help! Sum is returning 0 - Google Docs Editors Community
https://support.google.com/docs/thread/53834065/help-sum-is-returning-0?hl=en Jun 16, 2020 ... I am struggling with the sum function on 3 column of my sheet, I have tried to change formatting to make sure it is a number, I removed the $ symbol from the ...
My array formula is not recognizing the numbers listed in my ...
https://support.google.com/docs/thread/158253552/my-array-formula-is-not-recognizing-the-numbers-listed-in-my-reference?hl=en Apr 2, 2022 ... I have an array formula that that references badge ids with roster information. I'm trying to make the sheet to where I dont have to copy and paste the values ...
Trying to create a formula that ignores text, and uses a function ...
https://support.google.com/docs/thread/50810539/trying-to-create-a-formula-that-ignores-text-and-uses-a-function-inside-of-another-function-i-think?hl=en Jun 2, 2020 ... I am trying to make a formula to add one cell with both numbers and text to another cell that has numbers and text. The second cell however has to be divided ...
Looking to make a cell total the sum of all cells above it, where the ...
https://support.google.com/docs/thread/138338675/looking-to-make-a-cell-total-the-sum-of-all-cells-above-it-where-the-row-number-is-changing?hl=en Dec 2, 2021 ... I want it so that the cell used to display that total knows to total all cells above it, even when the row number its in will change, and the amount of cells ...
How to make the formula only operate when the adjacent cell is ...
https://support.google.com/docs/thread/21221377/how-to-make-the-formula-only-operate-when-the-adjacent-cell-is-populated?hl=en Nov 26, 2019 ... In F2, I am generating an array of random numbers, between 1 and the number of elements of the list. =ARRAYFORMULA(ROUNDUP(COUNTA(Sheet2!A:A)* ...
How to set a "Data validation" for cell expecting a number? - Google ...
https://support.google.com/docs/thread/200771014/how-to-set-a-data-validation-for-cell-expecting-a-number?hl=en Feb 6, 2023 ... ... formulas =isnumber(indirect((ADDRESS(ROW(),COLUMN())))) . However, I wonder if there is a much cleaner way to accomplish this supposed easy task ...
How can I change a number to negative based on a word in another ...
https://support.google.com/docs/thread/69737877/how-can-i-change-a-number-to-negative-based-on-a-word-in-another-cell?hl=en Sep 7, 2020 ... Basically, I am trying to figure out the formula to turn a number ... In the B cells I also have some conditional formatting to make the sell red ...
Change Number but keep Letter the same when dragging across ...
https://support.google.com/docs/thread/68284448/change-number-but-keep-letter-the-same-when-dragging-across-multiple-columns-on-the-same-row?hl=en Aug 31, 2020 ... ... numbers) then move those adjusted formulas to the correct spot. ... formula on your main sheet to convert that column to a row. Not easy ...