About 1,921,218 results (3,614 milliseconds)
IF formula returns FALSE while comparing to equal numbers ...
https://support.google.com/docs/thread/193901389/if-formula-returns-false-while-comparing-to-equal-numbers?hl=en Dec 22, 2022 ... The values are just too small to matter. When you are making comparisons, like for conditional formatting, using ROUND(xxx, 2) will be enough to ...
How do you create a conditional formatting highlight cell formula for ...
https://support.google.com/docs/thread/57660479/how-do-you-create-a-conditional-formatting-highlight-cell-formula-for-a-data-table?hl=en Jul 7, 2020 ... In the custom formula I have to use ROUND() because your numbers ... Here is my best guess at what might work in Excel but I'm not real ...
Use the rounded value of cells in a SUM - Google Docs Editors ...
https://support.google.com/docs/thread/169434960/use-the-rounded-value-of-cells-in-a-sum?hl=en Jun 30, 2022 ... To come to the batch size I use the ROUND or CEILING function. ... DOUGHS and see if the formulas in row 19 are producing the expected results.
ROUND function - Google Docs Editors Help
https://support.google.com/docs/answer/3093440?hl=en The ROUND function rounds a number to a certain number of decimal places according to standard rules. Examples Make a copy.
Formula Calculating Incorrectly - Google Docs Editors Community
https://support.google.com/docs/thread/56934089/formula-calculating-incorrectly?hl=en Jul 3, 2020 ... Then I apply the round() function and that fixed the problem. Again, this is due to the Floating-point Arithmetic issue. I hope others find this ...
IF function issue - Google Docs Editors Community
https://support.google.com/docs/thread/321201775/if-function-issue?hl=en Jan 28, 2025 ... ... formula, to round all of the values to two decimal places. Does this ... Microsoft Excel, Apache OpenOffice and LibreOffice use the ...
IF function issue - Google Docs Editors Community
https://support.google.com/docs/thread/321201775?hl=en&msgid=321203222 Jan 28, 2025 ... ... Microsoft Excel, Apache OpenOffice and LibreOffice use the ... formula, to round all of the values to two decimal places. Does this ...
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 ... If the result of the formula is negative, the function returns 0. ... decimal divider will use semi-colon instead of commas within formulas.
Why is this Conditional Formatting Not Working? - Google Docs ...
https://support.google.com/docs/thread/317838069/why-is-this-conditional-formatting-not-working?hl=en Jan 9, 2025 ... To resolve the problem, you can wrap the existing formula with the ROUND function. ... While the exact formula proposed will not work for me ( ...
Can you have Round function and Multiplication in one formula ...
https://support.google.com/docs/thread/99454814/can-you-have-round-function-and-multiplication-in-one-formula?hl=en Feb 23, 2021 ... I am trying to use the ROUND function to round multiple components at once. ... If you need more help, please share a sample spreadsheet that ...
2 Formulas in one cell? - Google Docs Editors Community
https://support.google.com/docs/thread/260333280/2-formulas-in-one-cell?hl=en Feb 23, 2024 ... ... ROUND function for this use case) or you could use CEILING or FLOOR if you prefer to round up/down. Original Poster SJ7897 marked this as an ...
Laggy and incorrect output calculations using ArrayFormula ...
https://support.google.com/docs/thread/50411830/laggy-and-incorrect-output-calculations-using-arrayformula?hl=en May 31, 2020 ... A condition is that after every new name, this formula will be a amended a little. Hence, I have an if() function to do so. This function is ...
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.
Rounding function/formatting for thousands and millions. - Google ...
https://support.google.com/docs/thread/129479184/rounding-function-formatting-for-thousands-and-millions?hl=en Oct 5, 2021 ... I have a sheet with some data. I'm using this sheet to merge data into another program. I'm looking for a way, if it exists, to have numbers ...
My IFS function does not get past the first Criteria. - Google Docs ...
https://support.google.com/docs/thread/57658193/my-ifs-function-does-not-get-past-the-first-criteria?hl=en Jul 7, 2020 ... ... work down your entire spreadsheet without you having to manually add the formula in each row. Q1. ={"Phone Status";ArrayFormula(IF(H2:H="","",
VLOOKUP with Rounding Up! - Google Docs Editors Community
https://support.google.com/docs/thread/3883132/vlookup-with-rounding-up?hl=en Apr 9, 2019 ... Looking to calculate the rounded-up Shipping Rate (column K). Example Row 2: Weight is 0.66 pounds. Lookup rounded up rate is 0.69 pounds, row ...
Calc sometimes off by a penny
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/mOUTCIpVHns To fix the error, put =round(...,2) around your formulas. Regards, Fred ... > Excel rounds this to 67.42 because you asked for 2 decimal places to > ...
How to combine an equation/function with ROUNDDOWN? - Google ...
https://support.google.com/docs/thread/115986517/how-to-combine-an-equation-function-with-rounddown?hl=en Jul 4, 2021 ... Sheets,Microsoft Windows,Personal use. Locked. Informational ... Please see if these formulas help? Read more about this function here ...
How can I change the rules on how to round? Not at what decimal ...
https://support.google.com/docs/thread/28066374/how-can-i-change-the-rules-on-how-to-round-not-at-what-decimal-place-to-round-at?hl=en Feb 8, 2020 ... ... formula in sheets to the 3rd decimal to show values before rounding ... If that's the case, you should be able to use this adjusted formula. = ...
2 digits after the decimal point - google sheet - Google Docs Editors ...
https://support.google.com/docs/thread/146658815/2-digits-after-the-decimal-point-google-sheet?hl=en Jan 19, 2022 ... If I use =ROUND(6,3;2) still gives 6,3 instead of 6,30. Somebody with ... The formula in column F in your sample spreadsheet does not work ...