4 ms·
According to later posts on this, many calculations which involve storing 65535 or 100000 really store the other one: Dana DeLouis writes: """ And if you mult
by randallsquared 19y ago
According to later posts on this, many calculations which involve storing 65535 or 100000 really store the other one:
Dana DeLouis writes: """
And if you multiply be say, 2 you get something else:
=A1 MUL 2
returns 131070, as if A1 had 65535. (which it should have been)
=A1 MUL 1
Keeps it at 100000.
=A1-1 returns 65534
=A1/1 is still 100000
=A1/2 retuns 32767.5
"""
Given that it would more often be the case that 65535 or 100000 comes up as an intermediate number than the final result, it could be that there are many calculations that have been done in error silently for those using Excel 2007.
EDIT: Replaced asterisks with MUL because I don't know how to escape them.
- henning 19y agoNew Arc suggestion: a Markdown/Textile implementation. :(
- oditogre 19y agoIs the formatting for news.yc documented anywhere, btw?
- henning 19y agoIf it is, link plz.
- lst 19y agoIs PG neglecting his users?! And how is this?! So he's a bad teacher, not following his own advices. That's sad.
- ced 19y agoProbably not. All I know: using one star on each sides of something for italics, two for bold, and if you put a space at the beginning of a line, you get fixed-width font (for code).