See likes

See likes given/taken


Posts you liked

Pages: 1 [2] 3
Post info No. of Likes
Re: Used Cars Master Thread
https://newyork.craigslist.org/brk/cto/d/brooklyn-2012-honda-civic-running/6987398275.html
Seems way too cheap for me.

September 27, 2019, 04:02:37 PM
1
Re: Used Cars Master Thread
right, so assuming I see the car and the mileage, etc is real, is there anything else to worry about? stolen? very hidden flaws?
You'll likely never see the car. They're probably scammers looking for people who will send them money to order the car. Not too long ago I tried replying to one of these ads to see what would happen (fake name, address, and throwaway email). Here are the emails that we traded, and screenshots of the very-ligit looking email that I got from 'Ebay'.


Yehudaa: Hi. I'm very interested in your Rav4. Please send me more info, and please let me know when I can come test drive the car. Thanks!

Patricia Davis: Hi there, thank you for your interest in buying my SUV. My 2013 Toyota Rav4 LE 4WD has 82,360 Kms, with a 2.5L I4 cylinders engine, automatic transmission. It is in perfect condition, no need for additional repairs,no scratches, dings or rust. The vehicle looks great. It runs like new and all services are up to date. Also, I need to mention that it was never involved in any accidents. The value is CAD $3,500. It belonged to my husband but he passed away(had a heart attack) so I decided to sell it because to be honest, it's only gathering dust in my garage.I just moved with my daughter in Saskatoon SK so I took the vehicle with me and gave it to eBay to handle the deal.The vehicle is at the shipping company, sealed and ready for delivery. It's quite hard for me to sell it in person because I'm 61 yo and age gets you eventually. But with eBay you'll get 5 days for inspection and if you're interested in purchasing it, send me your full name, shipping address and phone # so I can have them to send you an invoice, meaning more details about how they work. Also you are not obligated  to buy it, no pressure...I've attached more pictures!


Yehudaa: Hi Patricia. I'm so sorry to hear about your husband! Let's go ahead with this deal. My full legal name is (fake name). Shipping address is (fake address). Please let me know to pay for it and when it will be delivered. Thanks!

Patricia Davis: Hello, I apologize for my delayed response but I am very busy with my work,I have received your complete delivery details and right now I will forward the information to eBay. They will send you the invoice shortly and you will receive it by email with all the instructions and details. Please get back after you receive the invoice from them so we can complete our deal. Thank you!

Patricia Davis: I just got an email from eBay saying that they have sent you the invoice with all details you need in order to complete this deal. Please check your messages and let me know if you got it. Also,on the payment notification you will find their phone number where you can call and get more info from their operators. I will wait for your reply.

September 27, 2019, 04:09:29 PM
1
Re: Craigslist
cross-posting because this seems like a good place
I'm looking to buy a used car, and looking through craigslist there are a lot of cars that seem very legit but are significantly underpriced, is there a way of knowing when it's too good to be true and when it's just a guy looking to sell his car?
obviously, I'd only pay in person once I've seen the car (probably with a friend who knows about cars), but was what other things should I look out for, assuming it all checks out?

Always take it by a mechanic of YOUR choice, if seller doesn't agree run away.
Always check CARFAX by your own, or that you see that's it's running it from the real carfax website, don't trust a paper Carfax preprint from the seller.
And of course the first rule as always is : "if it's to good to be true" run away.

Good luck.

September 27, 2019, 04:42:53 PM
1
Re: Excel Help and Problems
what kind of formula would I need if I want conditions of multiple columns to add to a total? for example, if column A is more than 10 add 1 to the total, and if its less than 5 subtract 1 from the total.
TIA
This is a simple nested IF. Like (if the total is on column F...)
Code: [Select]
=IF(A1>10,F1+1,IF(A1<5,F1-1,"NOT DEFINED"))

October 25, 2019, 12:08:20 AM
1
Re: Excel Help and Problems
thanks, but I tried using that but it's not working, I think because once a nestled IF reaches a "true" it stops reading so it never reaches the next column. (unless I'm mistaken)
Do you need something like?
Code: [Select]
=SUM(IF(A1>10,A1+1,IF(A1<5,A1-1,"NOT DEFINED")),(IF(B1>10,B1+1,IF(B1<5,B1-1,"NOT DEFINED"))),(IF(C1>10,C1+1,IF(C1<5,C1-1,"NOT DEFINED"))))

October 25, 2019, 12:55:18 AM
1
Re: Excel Help and Problems
It does, but I removed the reference to the cell by the "value if true" because I want the total in the new column (where I putting the code), does that make sense?
it also comes back as #value if there is a number in between 5-10, anyway for it to just not change the total?
If it's between 5 and 10, you'll want to refer to the column from where it should copy the number in that case.

October 25, 2019, 07:57:58 AM
1
Re: Excel Help and Problems
It does, but I removed the reference to the cell by the "value if true" because I want the total in the new column (where I putting the code), does that make sense?
it also comes back as #value if there is a number in between 5-10, anyway for it to just not change the total?
Like this?
Code: [Select]
=SUM(IF(A1>10,1,IF(A1<5,-1,0)),(IF(B1>10,1,IF(B1<5,-1,0))),(IF(C1>10,1,IF(C1<5,-1,0))))

October 25, 2019, 11:29:29 AM
1
DEWALT 20-Volt Max 2-Tool Power Tool Combo Kit $79 pickup only https://www.lowes.com/pd/DEWALT-20-Volt-Max-2-Tool-Power-Tool-Combo-Kit-with-Soft-Case-2-Batteries-Included-and-Charger-Included/3441524
November 04, 2019, 12:13:22 PM
1
Re: microsoft mailmerge help You can try making a second row in your table with all the same info but the other email address
January 06, 2020, 05:27:26 PM
1
Re: microsoft mailmerge help looks like you need to separate the addresses with a comma and a space
https://support.yet-another-mail-merge.com/hc/en-us/articles/212124585-Send-email-to-multiple-recipients-at-the-same-time

Can you try that?

January 06, 2020, 11:39:18 PM
1