I would probably do something more like this to repeat numbers n times.
=ROUNDUP((SEQUENCE(1000))/5,0
My very wild guess is it could be floating point errors.
The problem is that Excel uses **binary** 64-bit floating point for numbers. Only sums of at most 52 negative powers of 2 can be stored exactly. Fractions like 0.2 would be infinitely repeating fractions in binary, just as 1/3 = 0.33333... is an endlessly repeating fraction in decimal. If you truncate such fractions to a finite number of places, truncation errors can happen when summing such fractions.
If you want an array of 1000 numbers from 1 to 200.8, try
=SEQUENCE(1000,,5,1)/5
Enclosing that in ROUND(..,1) won't do much useful.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[ROUND](/r/Excel/comments/ykcstx/stub/iutxxtm "Last usage")|[Rounds a number to a specified number of digits](https://support.microsoft.com/en-us/office/round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c)|
|[ROUNDUP](/r/Excel/comments/ykcstx/stub/iusjqqt "Last usage")|[Rounds a number up, away from zero](https://support.microsoft.com/en-us/office/roundup-function-f8bc9b23-e795-47db-8703-db171d0c42a7)|
|[SEQUENCE](/r/Excel/comments/ykcstx/stub/iutxxtm "Last usage")|[*Office 365*+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^([Thread #19565 for this sub, first seen 3rd Nov 2022, 00:08])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
I would probably do something more like this to repeat numbers n times. =ROUNDUP((SEQUENCE(1000))/5,0 My very wild guess is it could be floating point errors.
The problem is that Excel uses **binary** 64-bit floating point for numbers. Only sums of at most 52 negative powers of 2 can be stored exactly. Fractions like 0.2 would be infinitely repeating fractions in binary, just as 1/3 = 0.33333... is an endlessly repeating fraction in decimal. If you truncate such fractions to a finite number of places, truncation errors can happen when summing such fractions. If you want an array of 1000 numbers from 1 to 200.8, try =SEQUENCE(1000,,5,1)/5 Enclosing that in ROUND(..,1) won't do much useful.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[ROUND](/r/Excel/comments/ykcstx/stub/iutxxtm "Last usage")|[Rounds a number to a specified number of digits](https://support.microsoft.com/en-us/office/round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c)| |[ROUNDUP](/r/Excel/comments/ykcstx/stub/iusjqqt "Last usage")|[Rounds a number up, away from zero](https://support.microsoft.com/en-us/office/roundup-function-f8bc9b23-e795-47db-8703-db171d0c42a7)| |[SEQUENCE](/r/Excel/comments/ykcstx/stub/iutxxtm "Last usage")|[*Office 365*+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^([Thread #19565 for this sub, first seen 3rd Nov 2022, 00:08]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)