Timeline for Google sheets average between cells
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 23, 2015 at 0:43 | vote | accept | t56k | ||
| Jul 23, 2015 at 0:43 | comment | added | t56k | You were right, bad formatting. Thanks so much! Terrific answer. | |
| Jul 23, 2015 at 0:42 | comment | added | user79865 | Oh, from your screenshot it looks like the numbers are formatted as text: they are left-aligned. That is definitely a problem. Numbers should be numbers, otherwise you can't calculate with them. | |
| Jul 23, 2015 at 0:41 | comment | added | user79865 | This is what it does for me. Check that your column isn't formatted to show just the integer part? | |
| Jul 23, 2015 at 0:37 | comment | added | t56k | My bad, it's a rounding error. I'm dealing largely with decimal places. Can the JS be amended to deal with floats and not just integers? Or do I have to multiply and divide? | |
| Jul 23, 2015 at 0:34 | comment | added | t56k | That's a really cool solution, I didn't know you could write Javascript functions in Google Sheets. This function just fills everything in with zeroes though? | |
| Jul 22, 2015 at 6:48 | history | answered | user79865 | CC BY-SA 3.0 |
