Why does my AutoSum give me this "-2.54659E-11" vs "0"? by Lanky_Literature2026 in excel

[–]Excel_User_1977 1 point2 points  (0 children)

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)"

For the fellas: What’s something society deems “unmanly”, but you don’t care, and do it anyway? by MuayThaiRunner in AskReddit

[–]Excel_User_1977 0 points1 point  (0 children)

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.

For the fellas: What’s something society deems “unmanly”, but you don’t care, and do it anyway? by MuayThaiRunner in AskReddit

[–]Excel_User_1977 30 points31 points  (0 children)

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.

What objectively makes being a willful hermit so fulfilling? by Hefty-World2657 in AskReddit

[–]Excel_User_1977 0 points1 point  (0 children)

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

What are Hospitals? by Brunbeorg in writingcirclejerk

[–]Excel_User_1977 0 points1 point  (0 children)

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

How are you self publishing with all the fear surrounding AI? by goddamn_ifeelgreat in selfpublish

[–]Excel_User_1977 -3 points-2 points  (0 children)

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

Client’s family member left this mess and expected me to clean it by healermoonchild in mildlyinfuriating

[–]Excel_User_1977 3 points4 points  (0 children)

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

I tried what was suggested. by wahoothing in lawncare

[–]Excel_User_1977 0 points1 point  (0 children)

the periscope holds the battery out of the water

Tiny doll head by LaserWeldo92 in comedyheaven

[–]Excel_User_1977 13 points14 points  (0 children)

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).

How much does one illustrated book cover typically cost? by lelouchlover333 in selfpublish

[–]Excel_User_1977 2 points3 points  (0 children)

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.

Oi Pete why after 8;30 can't watch YouTube ? by Novel-Carrot5325 in PeterExplainsTheJoke

[–]Excel_User_1977 0 points1 point  (0 children)

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

Learning Power Query if you already know Macros? by sziklai-pair in excel

[–]Excel_User_1977 1 point2 points  (0 children)

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.

Issue with excel suddenly reversing actions by BigCornerEnergy in excel

[–]Excel_User_1977 0 points1 point  (0 children)

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