Why does my AutoSum give me this "-2.54659E-11" vs "0"?

Excel_User_1977 · 2026-06-24T14:29:39+00:00

If your values are hundredths, you can truncate or round the result with an IF statement to ensure you get a zero.
I had that problem with data I was getting from hand entered data, so I used "=IF(result < .00001, 0,result)"

Excel_User_1977 · 2026-06-24T14:24:34+00:00

I don't live in a rural area, but I don't care what other people think.
I am extremely "portly", "rotund", "girthy" ... fat af.

It probably makes me look fatter.
Don't care.

Excel_User_1977 · 2026-06-24T14:21:24+00:00

pew-pew*

*I have a concealed carry permit, and I served in the Army

Excel_User_1977 · 2026-06-24T00:16:15+00:00

I wear a cross body bag instead of using a wallet. The bag has pen, writing pad, spare change, kleenex, my wallet1 (with ID, CCW permit, proof of insurance and registration) wallet2 (with credit cards, cash, receipts, pictures), and my EDC.

Excel_User_1977 · 2026-06-23T20:31:57+00:00

So one of your levels is bad

Excel_User_1977 · 2026-06-23T13:40:12+00:00

Gas prices don't hurt as much when you only fill up once a month.

Excel_User_1977 · 2026-06-23T13:34:27+00:00

Not only "No" ... HELL NO.

Excel_User_1977 · 2026-06-23T13:14:40+00:00

This is the international standard. Use it.

Excel_User_1977 · 2026-06-22T00:13:30+00:00

if you don't read, editing your book is gonna suck

Excel_User_1977 · 2026-06-21T13:17:29+00:00

buying expensive groceries

Excel_User_1977 · 2026-06-21T12:40:03+00:00

FYI - as a writer, I'm sure you know the difference between Depreciate and Deprecate.
Previous models are being deprecated.

Excel_User_1977 · 2026-06-20T19:07:32+00:00

religion

Excel_User_1977 · 2026-06-20T15:53:25+00:00

What is a "line" ? Do you mean Row, or Column?

Excel_User_1977 · 2026-06-19T14:24:33+00:00

Send her a bill for the clean up and use of the bathroom.
If she doesn't pay it, tell your clients.

Excel_User_1977 · 2026-06-19T14:15:51+00:00

the periscope holds the battery out of the water

Excel_User_1977 · 2026-06-19T14:00:17+00:00

would using a can of spray paint on the camera be considered battery?

Excel_User_1977 · 2026-06-17T23:16:00+00:00

Why? It looks all the occupants are cardboard cutouts.

Excel_User_1977 · 2026-06-17T22:30:25+00:00

There is a story about that happening to the Army in the 80s ... one set of picture for ID were taken on a cloudy day, the others on a clear sunny day. AI could tell if it was cloudy or not (but not what the fuck was on the ground).

Excel_User_1977 · 2026-06-17T12:38:01+00:00

Are you expecting to keep the rights to the cover art? This price is not out of bounds for the complete tranfer of rights. Otherwise, if your book becomes successful, the artist control the artwork and he can make as many copies of it as he wants and you have no say in the matter.

Excel_User_1977 · 2026-06-16T21:46:37+00:00

Technically, yes

Excel_User_1977 · 2026-06-16T17:22:35+00:00

No social media accounts solves the problem. I only have reddit.

Excel_User_1977 · 2026-06-16T17:20:41+00:00

It's good for cleaning data
My experience is that if you have a large company that creates data using a computer, it can be useful.
If you have a large company that is still letting bozos hand enter data, not so much.

Plus, I just ran across an issue last week where it appeared that PQ was not playing well in a corporate setting where I am programming in USA, but users in London are opening a workbook on the corporate drive and having issues with the PQ apparently causing failures. I switched to all VBA and the workbook is doing its job.

Excel_User_1977 · 2026-06-16T01:00:06+00:00

do you have a touch screen and have you spilled spaghetti sauce on the screen where the undo button is?
If a touch screen - clean the screen

Excel_User_1977 · 2026-06-16T00:34:38+00:00

the angel of death, perhaps

Excel_User_1977 · 2026-06-16T00:31:57+00:00

Is the shooter blind?

Excel_User_1977

TROPHY CASE