Jay B

Having some Excel formula trouble...

My E column contains drop down boxes w/ values associated with them. I used "IF" function so that meets=100, does not meet=0, etc. When I choose meets or does not meet, it enters the 100 or 0 value in column F. Now I want to find a way to average all the populated values in column F.

Example: If I have 2 fields where 1 meets (100) and one does not meet (0), then the average of the two fields would equal 50.

Make sense? Thanks for the help ahead of time.

I'm having trouble with a situation at work. This week we rec'd our Annual Reviews from last year. My manager gave me a good review for the most part, but one sentence really bothered me.

"Employee has difficulties respecting others, including her manager."

I am shocked, to say the least. While my manager and I do struggle with our remote relationship (she is in one state while I'm in another - virtual management only), I have never been disrespectful to her. We don't always see eye to eye, and I do stand up for myself, but only in a professional manner. I can be firm, but certainly never disrespectful - and my job performance exceeds expectations. I feel this is a personal attack. These are the reasons why:

1) We had a verbal disagreement in February this year (in which I was very respectful but did stand up for myself), which should have no influence on my annual review from this past year.

2) This has never been brought to my attention before, throughout the entire year last year. All my monthly evaluations were above average. My boss NEVER indicated that I was being disrespectful. Never said a word - not on documented evals, never rec'd verbal counseling. Nothing. How can I be expected to fix an issue, when I never knew it was an issue in the first place?

3) She gives no examples as to how I've been disrespectful. I have no incidents, dates, or other pertinent information to determine why she's labeling me as disrespectful. Who have I been disrespectful to? When? What did I do? She simply states "its been an issue" and she'd like me "to work on it" and won't elaborate further.

I'm just taken aback, and at a loss for how to respond to this 'accusation' (for a lack of a better term). I don't feel this is an accurate representation of my past year with the company, and feel like this is a blatant personal attack.

Any suggestions of how to approach this situation? I'm supposed to sign my annual review and return to her to then be sent to HR, but I feel very uncomfortable signing this document. I can add my own employee comments, but want to do so in the most appropriate way. Should I contact HR? Any suggestions would be helpful. Thank you in advance.

I am 4 months pregnant and starting to show. Time to buckle down and buy some clothes!!!

After looking online, I am dismayed by the unaffordable prices for maternity wear. Even the 'family friendly' places like the Gap, Kohls, and Old Navy have high prices. I have a Motherhood Maternity and Mimi's Maternity in my local mall and they have your typical boutique prices. With a 4 year old child and one on the way, I just can't fathom paying $35 for a single blouse, and $50 for slacks.

I don't mind if the clothes are gently used....only wear them for a short amount of time anyway. I've checked my local Craigslist without much luck. Amazon and Ebay have somethings available, but I would have to pay multiple shipping costs since the items are sold by individual sellers.....

I realize that my best bet is to go to a consignment or thrift store to locate inexpensive items....and I definitely plan on doing that. Just wanted to see if anyone knew of anything online on that would be reasonable as well? Maybe a discount store or one that offers whole sale prices on single items? Thanks in advance for your help!

I'm 23 years old, married, and have a 4 year old with my husband. We have been together for 6 years now. We own a home, 2 cars, rec'd our college education, and have steady, good jobs. So whats the problem???

When I told my mom I was pregnant at 19, it was a traumatic experience as a first time mother. We weren't yet married, still lived in an apt, and basically didn't have a pot to piss in. I told my mother in the privacy of her home, next to my dad, in a calm fashion. She flipped. She screamed at me. Told me all the things wrong I'd done in my life, all my bad decisions. She reiterated how I didn't have anything: no education, no money, etc etc. "Why are you making the same mistake I did!?!? I didn't want you to end up like me!! How can a baby raise a baby?" It was horrible. I cried and she wouldn't stop coming at me. After, I feel into this deep depression.

Of course after my daughter was born, my mother accepted her grandchild. She loves her and always talks about how wonderful, smart, beautiful, etc my daughter is. She's never been a motherly/grandma type so they don't spend much time together. But she does give advice and financial help when she can.

I guess I'm just having deja vu. I do not want that same crappy experience to happen again. Not when I'm an adult and established. My husband and I didn't plan the 1st child. Nor did we plan this one (and had been using birth control routinely). I refuse to let her beat me down verbally like that again. I am no longer willing to listen to her rude, screaming rants. I think this pregnancy is, though unexpected, a good thing. I have to think optimistically about this b/c my mom will most definitely be negative. If I have to accept what life throws at me, she should too - there's nothing I can do to change this situation, just accept it!

I have an idea of how I want to approach this, but want to get some suggestions first. So to my fellow Yahooers......Any advice/suggestions on how to go about telling her? I do not want to be rude or disrespectful to my mother. I love her dearly. But at the same time, I do not wish to be verbally attacked either. It's not ok anymore. It wasn't ok the first time around, and it not ok this time either. Should I tell her in a public place or in a private residence? What should I say to her?

Thank you in advance for your responses and suggestions.

Inflation is getting ridiculous. I'm having trouble living a normal, modest, everyday American life....

I am working on a project for customer service training....

needing examples of difficult situations that can occur when taking an incoming general customer service call. (I'm in the healthcare/insurance field if that helps). This is to improve our customer service skills when taking incoming calls.

Any experiences or ideas would be appreciated!

Or any complaints you've had about places you've called.

ie:

1. caller has had phone tree issues and is very irritated.

2. caller is upset because their request isn't being handled.

3. caller who is rambling on and on about irrelevant topics.

Thanks!!!!

My husband & I have been married for 1 year, & have been together for 4 years. We barely made it to the 1 year mark. My husband has had some troubles with drugs/law before we started dating. He changed his ways when we got together, became clean, & all was well. Now it's trickled into marriage. After we got married he started drinking/drugging again. Not as bad as it was before me, but bad enough to make me feel uncomfortable. This year, he got into trouble with the law, not once, but 3 times. We have one child together. I'd have to wake up our child in the middle of the night to bail him out of jail (twice). Paid lawyer fees & everything. He promises he won't do it again, but I don't trust him. I just don't see why he would jeopardize his family for something so stupid. Not only do I not trust him, but everything he does now seems to annoy me. Every word, every action. It feels like he is my roommate, not my husband. I'm tired of having to pick up pieces & fix it all.