Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
![](https://s.yimg.com/ag/images/4533/24272345628_a09a78_192sq.jpg)
GTHG ♥
Excel: Help with IF function?
I'm a dog walker - I'm trying to create a spreadsheet for clients and their dogs, when they've been walked and if I've been paid. I currently have columns for Date walked, Walk complete, Owed, and Paid.
I'm trying to add an extra column on the end of these to turn red if I've written "YES" in the Walk complete column, but nothing in the Paid column (to indicate that I'm due payment). Preferably, also to turn green once I've written "YES" in both the Walk complete and the Paid column (to indicate that payment has been dealt with).
I've tried adding a screen grab to make it all clearer but not sure if it's accepted it.
TIA
1 AnswerSoftware3 years agoAdvice with a tenancy contract please?
Okay, so. I moved into my landlord's spare room as a 'lodger' (the legal term, apparently) at the start of August. He permitted me to get a puppy to keep his dog company and, of course, the puppy can be noisy at times, which is an issue for him at night before an early shift/in the morning after he's done a night shift. Long story short, he won't allow me to rectify the issue (puppy needs to be just ignored when he whines at night, which will get worse before it gets better) because it wakes him up and I have to rush down and give puppy attention every time he whines, which is counterproductive.
His dog also attacks mine when mine gets too much attention or gets anywhere near his food, which my landlord hasn't been willing to work on - despite my research and suggestions on how to rectify the situation so that the dogs are happy. Because of his failure to even attempt it, I started looking for other places to live (which he was aware of) a few days before he sent the message described below.
So, on 8th Nov he gave me notice and said "Should we call December the last month? Earlier if it suits both parties?" to which I said, "End of December is fine with me."
The contract we both signed states that the notice period is "One month minimum, two months appreciated."
-question continued in additional info-
1 AnswerOther - Politics & Government4 years agoHow do I get my own business email address?
I m making an email account for my small photography business. Is there a free/cheap way I can get a professional-looking email address, like myname@businessname.co.uk or something along those lines? TIA
2 AnswersSmall Business5 years agoCan I study in the US and work at the same time?
Obviously the normal student Visa wouldn t allow me to work - but does anyone know of some sort of special form I can request in order to work, too? I plan on doing a part-time course that s going to cost me several thousand pounds anyway, so saving up is going to be hard enough - without having to save for all my living expenses while I m there!
4 AnswersImmigration5 years agoFlying from the UK to the US - what do I need?
I'm going for a little over a week. The person I'm visiting has bought my essentials already - deodorant, face wipes, shampoo - everything I'll need except makeup.
I mean the things like, do I have to fill out an immigration form beforehand or will I be given one to fill out during the flight? That kind of thing.
I'll be flying with Delta if that makes any difference.
2 AnswersPacking & Preparation5 years agoShould I bother contesting this speeding ticket?
On 24th Feb I was stopped for speeding. Got the ticket, was told I would receive the letter offering me a speed awareness course within 14 days, went on my way. Today, on 10th March, I ve just received the letter - 15 days after I received the ticket (not including the day I was stopped). I ve done some online research and if websites make any comment on the time limit the police have to send the NIP, they say it s a 14 day time limit. Not 14 working days or anything like that. I just rang the police non-emergency number the question it & then ask how to appeal it since it was a day outside the time limit, and the lady said that her colleague had told her that the NIP is to be issued within a reasonable amount of time , not within 14 days, and that 15 days was still reasonable. Since I was told by everyone - starting with the police officer who wrote out my ticket - that I would receive the NIP within 14 days, do I have a leg to stand on if I contest the ticket?
10 AnswersLaw Enforcement & Police5 years agoHow do I turn up the bass in my Toyota Aygo?
It s a 57 plate. Surprisingly the owner s manual that came with the car had nothing even vaguely useful. Any help?
1 AnswerToyota6 years agoWhat would be the female equivalent of a topless waiter?
For example, I know some guys who are 'Hunks in Trunks' and they go to hen parties (generally) and just chat to the women, take photos and get them having fun and playing games.
Apart from being a topless waitress or a stripper, what do you guys reckon would be the female equivalent - no nudity involved?
1 AnswerSingles & Dating6 years agoWays to stop my feet slipping toward the front of my new heels?
I've just bought new heels - the size below squashed my feet and I'm not normally that size anyway. However the size I bought means my feet have room to slip down toward the toe, meaning my heels slip in the shoes. I bought a foot comfort thing for the balls of my feet but no luck. Any advice?
1 AnswerFashion & Accessories6 years agoHow to break the news of my belly piercing to my mum?
I turned 16 almost exactly 3 months ago, and almost 2 months ago I got my belly pierced without my mum's consent or awareness, but I can legally consent to it being done myself.
Before I got it done I'd been wanting it done for at least a year, so it wasn't a rash decision. I checked out the piercing place before; reviews etc said they're really good, friendly and make everything easy and sterile and all that (and they lived up to it when I went in).
So it's been almost two months and my mum still doesn't know, how could I break it to her that I've got my belly pierced? I was thinking of waiting till it's more healed, then going out, coming back and saying "Mum I got my belly pierced today!" and I'll pretend that it's just healing really well.. Any better ideas?
2 AnswersOther - Skin & Body8 years agoHow can I find my Visa activation code?
I'm trying to sign up to Verified By Visa so I can buy something online with my new debit card (I've had the PIN through and my mum's put money onto the account) and it's asking me for my Visa activation code.
I rang up HSBC to try to sort out my security code for online banking and I can only assume that that was me activating it in the process? Someone please help!
If I have activated my card and I've now lost this code, is there a way of getting hold of the code so I can do this?
2 AnswersSecurity8 years agoUncontrollable vaginal discharge, what's happening?
I'm 16 and have been sexually active with my boyfriend, who is also 16, since October last year. I've had the implant for over a month now and sex is legal in the UK at my age so don't talk about that.
Basically, the past few days I've woken up in the morning and I sit there for a few minutes trying to wake up a bit, then once I move I basically just leak some kind of liquid. It's very watery (like urine) but I don't believe that I keep wetting myself every morning, because it's not that sensation (it feels like it's inside my vagina).
I sit on my heel to stop the flow because if I sat normally, it'll still come out. I try sucking in while I run to the bathroom to sort myself out and by the time I get there it's running down my legs..
This has happened once or twice before in the years I've been through puberty, but it's never been this consistent. The only reason I thought of urine is because I used to have bladder issues, but they're not a problem any more.
It makes me feel gross, and I'd like an explanation please!
1 AnswerWomen's Health8 years agoCan I use the solution for my contact lenses to clean my navel piercing?
I don't have the solution in a bottle or anything; I have daily lenses that I throw away so the solution I'd use is in the little sachets with the contacts in.. But if I took the contacts out with clean fingers and used a cotton bud to dip in, would that still be sterile? Or would it not be advised? Thanks
1 AnswerOther - Skin & Body8 years agoI restarted my period less than a week after stopping it?
I was wondering if this has happened to anyone else. I started taking Cerazette (birth control) 6 weeks ago, and at first had my normal period, except it was only 3 days, from the 3rd to the 5th of May.
My GP did say that my periods could change to anything; they could get longer, shorter, or could just stop altogether. Obviously I thought this was fantastic news as soon as I stopped my first period as it's so much shorter.
But on the 26th of May, I started again, and again, nothing changed except the length. This time it was exactly a week long, then had some brown discharge which isn't really abnormal. I stopped this period on the 1st June, and now it's back. I started again on the 7th.. 6 days after my previous one stopped.
Has anyone else experienced this, or is it something I should talk to my GP about?
I should note that the last week or so I've been up to 3 hours late taking my pill on some days, since it's the holidays and my alarm never seems to wake me up. But I did Google it, and apparently it's fine to be 3 hours late.
Any help?
1 AnswerWomen's Health8 years agoWhat dog breed is this?
My brother saw one in a music video and wanted to know, I can't think of the name for the life of me.
11 AnswersDogs8 years agoCan you undo derestricting of a 50cc moped?
I'm looking for my first moped and in case this is an obvious question, you can tell I'm pretty much clueless so be nice!
I've found a moped that's cheap and only has a water leakage problem which my dad would be able to fix for me, but the advert says it's derestricted. Now since I'm only 16 riding it would be illegal, but this bike seems pretty perfect so I was wondering whether you can undo derestricting of a moped, or is it irreversible?
Thanks
4 AnswersMotorcycles8 years agoCould I legally move out of my parents' house?
I'm 15, turning 16 in July. The conditions in my home are quite honestly disgusting, it's full to the brim with rubbish that we don't need (to the point that we can't physically get into 3 of 7 rooms) and I sleep in the same room as my dad and two of my older brothers in bunk beds, while my other older brother sleeps in a caravan we used to use for holidaying. My mum sleeps on the sofa in the living room, which again we can barely get into. The house is infested (well, I say infested..) with mice, slugs due to damp and God only knows what else since we don't have a clue what's in the inaccessible rooms.
I'm not neglected, I get food, care, etc., it's just the state of my house and garden. I think if child services knew about the condition of my house, they'd probably remove me from my parent's care until I was at least 16 (I'm not entirely sure about this). I've never had anyone visit me in my house so I feel that this has socially held me back and effectively ruined my childhood.
However, I started a relationship with someone last July and we've been together since; we've had our ups and downs, but what couple doesn't? My boyfriend turned 16 last November and we're a genuine couple, not an immature relationship that'll last a year at most, we're both in it for the long haul. He's planning on getting a job at a farm nearby (it's practically guaranteed since the manager of the farm he currently lives on knows the manager of this farm), and if he gets the job he'll be given a flat nearby to live in so that he's close to the farm. My boyfriend said that it's a possibility that if he gets this job and flat that I could move in with him to get away from my house and my slightly possessive mother (I know she's supposed to look after me, but I think she's being obsessive over my safety). Because of this reason, I don't think my mother would give consent to my moving out, but my dad is more flexible and has previously said, "I don't mind what my kids do, as long as they're happy."
It's only a 20 minute drive from my current house so it's not like I'd be cutting all connections with them. It would be easier to get a job for me since it's in a large village with lots of shops etc., so I would probably be able to be fairly financially stable if I were to move there. I'm also planning on continuing my education in sixth form.
I just don't think I'll be able to cope with the social and mental aspects of living in such a neglected house; just recently our new neighbour complained to the council about our back garden so we're clearing it up before they come back to check it out again, but I think as long as they don't see the inside of the house, nothing will be done about the conditions inside. I don't think it's a suitable place to raise any child, and I don't want to spend the rest of my teen years being socially deprived like I am now.
So, at 16, would I be able to legally move out of my current residence to more comfortable housing, with possibly one parent's consent?
Thank you for any answers.
8 AnswersLaw & Ethics8 years agoHow can I get rid of the malicious content on my Tumblr?
I've been on my Tumblr daily for at least half a year now, and have not had problems. All of a sudden, I click the link to go on my blog (which leads me straight to it) and it comes up with a warning from Chrome: https://pbs.twimg.com/media/BIujjlzCAAIZ7yi.png:la...
How can I locate whatever it is that has the malicious content on my blog and get rid of it, or is there no hope? I really don't want to have to abandon my blog.
This was fine yesterday and now I can't get onto it, and my boyfriend said he can't get onto it either. I deleted a few posts from people I don't normally reblog from and don't follow (from the dashboard) and it's still the same.
Any help?
3 AnswersSecurity8 years agoContraceptive implant?
I've got an appointment to see my GP about the implant, and I was wondering if she'd inject it straight away or have me book another appointment? Obviously we'll have to talk through stuff first to make sure it's the right contraception for me but if it is, would they have to order one specially for me or would they have them in stock so that they can do it straight away?
2 AnswersWomen's Health8 years agoCopyright mark on Sony Vegas videos?
I'm making an equestrian MEP on Sony Vegas Pro, but I don't have the actual thing so I've been using pretty much every free trial I can find until I can convince my parents to buy me Vegas. I've got all the parts I need and I've added them to Sony Vegas Pro 12,0 trial, and it has a small mark in the corner of the clips, like so; https://pbs.twimg.com/media/A6-EViKCQAAO-c6.jpg
Will this stay here? And if I can, how can I get rid of it?
Thank you :)
1 AnswerCamcorders9 years ago