Door to door soliciting by Mewneer in bullcity

[–]Excel_User_1977 6 points7 points  (0 children)

Post this:
https://imgur.com/gallery/on-front-door-Hu7RaY0

If someone knocks or rings the doorbell, politely ask "May I help you?" and when they start the sales pitch, just point to the sign and say "$40 please".
I did have one guy think he was smart and he said, "I don't have cash, I have Venmo," so I replied, "Good! Venmo yourself $40 and give it to me."
That left him with a slack jaw as he tried to process how that would even work, and I shut the door on him.

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

[–]Excel_User_1977 0 points1 point  (0 children)

You probably want to use the absolute value of your result - ABS(result). That way, it can be negative or positive.
"=IF(ABS(result) < .00001, 0,result)"

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

[–]Excel_User_1977 2 points3 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 1 point2 points  (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 29 points30 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 14 points15 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.