MSE Parents Club Part 10

BrunoM

My_Fathers_Daughter wrote: »

Any Excel whizzes on?

I want a formula that says:

if D61, E61 and F61 all say Y then G61 (the cell with the formula in) should be the same as C65.

But I can't get it to work I hate IF formulas




BM your MIL sounds LOVELY :A

A nested If does it MFD -

=IF(D61="y",IF(E61="y",IF(F61="y",D65,""),""),"")

there are some more elegant ways praps, but that's the easy straightforward one.

searching_me

beanie i think you need a break and a good hour nap ... either that or a good chat with a mate x

BeenieCat

Aww Aless he's lovely - i never think to check facebook for new pics, i'm rarely on there nowadays.

maz thaks for the reminder i forgot to reply to that. For me it depends on what time we'd meet, and what day etc. because i have to be back here just before 3 for school. It's about 40 mins from here (but remember, i'm a nervous driver lately so can't go above 55mph :rotfl:)

SM i'd have liked a nap today but i'm still waiting for the plumber

(keeping the link for rolleyes permanantly in my clipboard seeing as i use it a lot )

Mazcabs

My formula brain is not working at the mo sorry - oh you have some answers good

Just back from having a haircut and typical LO was asleep for OH all the time I was out and has now woken up !!!

Mazcabs

BeenieCat wrote: »

maz thaks for the reminder i forgot to reply to that. For me it depends on what time we'd meet, and what day etc. because i have to be back here just before 3 for school. It's about 40 mins from here (but remember, i'm a nervous driver lately so can't go above 55mph :rotfl:)

:rotfl:I keep thinking I have posted things that I dont remember but then I check and its Newbie Maz!!:rotfl:

Buttonmoons

I 100% agree with swaddling, just use any ol' blanket. Worked a treat for us.

Karen - Well my gut reaction was to never talk to them again (well just the MIL) but at the end of the day, it's her upbringing that made her say that, It's easy to dismiss a potential child when the person isn't even showing that they are pregnant. When Keira got here she was great, although pushy and bossy, but then so was my mum, only difference is I told my mum to !!!!!! and P*** off and I made OH tell his mum that :rotfl:

Don't get me wrong, I actually love OH's mum now, she is great, and I don't hold what she said to mean much, just one of those kneejerk reactions. Kinda like OH when he found out I was going to keep the baby (I wasn't originally, long story) he asked me to marry him. I was........NO! I was 17 !!!!!!......Can handle a baby, but having to marry into his family with his witch sister :eek: Plus where the hell was I getting money to pay for a wedding lol.

BeenieCat

I thought that when i said it, how do we get around this then?!

Buttonmoons

Oh and the snoring thing. Yes it would be easy enough for me to buy some over the counter stuff for him (If he even works that stuff) But one of my main issues with OH is that he is incapable of doing anything for himself, due to lazyness.

If it wasn't for me, none of the bills would get paid, no food would be in the house except birds eye ready meals, and Keira would be living off fish fingers. Easy peasy.

He is just bone idle, and I understand he has a tiring job, but it only takes 2 minutes on a Saturday to nip in by the Chemist. He is almost 28, it's about time he grew up and realised I won't be doing everything for him like his mother.

I had to book his driving lessons !!!!!!....

My_Fathers_Daughter

karen1907 wrote: »

MFD - I am good at Excel but I am so tired today there is no chance I coul give you anything that worked!
Something like IF((((D61=Y),IF(E61=Y),If(F61=Y),C65,x),x),x) I think my brackets might be in the wrong places

Thanks Karen, that is about to where I got and it doesn't quite work!

BrunoM wrote: »

A nested If does it MFD -

=IF(D61="y",IF(E61="y",IF(F61="y",D65,""),""),"")

there are some more elegant ways praps, but that's the easy straightforward one.

But that does :kisses3:

Thank you so much for helping me with my totally parenting related problem

newbie_maz

Mazcabs wrote: »

:rotfl:I keep thinking I have posted things that I dont remember but then I check and its Newbie Maz!!:rotfl:

Sorry! :embarasse