3 ms·
> So, if you have `1234` in A1 and `5678` in B1, `=A1+B1` should by default produce `VALUE ERROR` rather than `6912`? If they were text, I'd expect it to end u
by Kamq 4y ago
> So, if you have `1234` in A1 and `5678` in B1, `=A1+B1` should by default produce `VALUE ERROR` rather than `6912`?
If they were text, I'd expect it to end up as `12345678`, personally. + being reasonably commonly overloaded to mean string concatenation.
- fragmede 4y agoWat.
- oarsinsync 4y agoExcel uses & for string concatenation. Excel considers + to be an arithmetic operation. Excel is a spreadsheet.
- replygirl 4y agoyou are so not the target user my dude
- Kamq 4y agoMaybe, but it seems weird for it to be completely unreasonable for operator overloading to be a thing, but also expect the user to have a working knowledge of basic data types.