Forum Discussion

dscheikey's avatar
dscheikey
Bronze Contributor
Sep 10, 2022

The help page of the TOCOL function describes an error by a non-integer number that does not happen

Hi community,

the help page of the TOCOL function describes an error by a non-integer number that does not happen.

I tried it out. I was able to work with comma numbers. No error occurred. Where can I report such errors?

Also, in the note: Excel returns a #NUM when array is too large, you could mention that the problem only occurs when the number of cells is not large enough to be displayed. The problem does not occur with a certain number of required cells.

As a third point, it should be mentioned that in the German help the German function name ZUSPALTE() is not given.

https://support.microsoft.com/en-us/office/tocol-function 

excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Sep 11, 2022

    Good catch! I've tested this with 400+ non-integers (Produced with RANDARRAY and then obtained by evaluating using F9 in the formula bar to create the array constant) and cannot produce a #VALUE! error. One or more non whole numbers seems very low. Maybe this was a bug caught early on (and resolved) when TOCOL was in BETA and the article hasn't been updated?

    I see TOROW contains the same notice.

Resources