Timeline for How to fill range of cells with same value using formula?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 28, 2023 at 15:21 | comment | added | Erik Tyler |
That is not what the poster asked. And these days, most would recommend the newer function anyway, which can handle any input: =MAKEARRAY(15, 6, LAMBDA(x, y, 0)) 0r =MAKEARRAY(15, 6, LAMBDA(x, y, 2.16)) or =MAKEARRAY(15, 6, LAMBDA(x, y, "cat")) etc.
|
|
| Feb 28, 2023 at 9:31 | comment | added | Matěj Kříž | Note: the SEQUENCE function works only with integers without decimal. support.google.com/docs/answer/9368244?hl=en | |
| Jul 10, 2021 at 11:24 | vote | accept | andio | ||
| Jul 10, 2021 at 10:58 | history | answered | Erik Tyler | CC BY-SA 4.0 |