****Bank Holiday Chat! May 22 and onwards! Whoooop!***

Toto

Burlesque_Babe wrote: »

Hi all

Have a lovely time Sally :wave:

Jamie Oliver has a bolognaise recipe with a whole tube of tomato puree in! I've never tried it though, I just use a decent squeeze of it or a dollop of tomato sauce. I add a decent splash of worcester sauce or a squeeze of brown sauce, depending on which I have.

I have an interview........for the job I was saying about yesterday (the one with possible, but rare contact with Cruella)...I had a reply today to the email to say I had been shortlisted and I would be written to. The interviews are on the 27th (which I knew) but as that's only 5 days away and only 2 working days due to the bank holiday - they are leaving it late to contact candidates.......so I wonder if they went back and looked at my application and thought - whoops, disability........

I have VERY mixed feelings about it for a number of reasons, but I'll go and see what happens.

Well done on the interview BB.

But isn't it just as likely that they were always going to bring you in for interview, disability or not. And isn't it highly likely that they were just really slack in contacting people and have only just got around to it?

There's also the possibility that you are the only person whose applied worth consideration, so no need to get a wriggle on really.

becky_rtw

I dont mind spiders tbh its things with lots of legs I dont like *shudders*

postingalwaysposting

Congrats BB and good luck :j

*making wedding invites all night :rolleyes: joy*

redsquirrel80

Toto wrote: »

Well done on the interview BB.

But isn't it just as likely that they were always going to bring you in for interview, disability or not. And isn't it highly likely that they were just really slack in contacting people and have only just got around to it?

There's also the possibility that you are the only person whose applied worth consideration, so no need to get a wriggle on really.

^^^^^ What Toto said :T Main thing is that you've got an interview and you are the best person for the job.. and as I probably won't be back online until 27th.. loads of luck (not that you need it ) xx

spud30

Well done on the interview BB :T

InkyCats20

Ah Squizz

Boring formula type excel formula type question: -

Can you do a SUMIF based on 2 conditions ?

Person has employee number but is split between 2 cost centres, I want to add up all their costs from great big payroll list dumped out of system into excel but make sure the relevant bits go to the correct cost centre - IYSWIM !!!

Burlesque_Babe

ta all. I guess I just have my cynical head on today

The thought of working there doesn't fill me with any excitement, but, as the merger has now slipped, I just can't afford to stay there anymore, but I love the place so much, it's like a family.

However, the job was 30 hours on one advert and 37 on another. 30 hours would be only 16k, so still would need lots of teaching and AQA on top (just not as much), so that's another aspect to consider.

redsquirrel80

InkyCats20 wrote: »

Ah Squizz

Boring formula type excel formula type question: -

Can you do a SUMIF based on 2 conditions ?

Person has employee number but is split between 2 cost centres, I want to add up all their costs from great big payroll list dumped out of system into excel but make sure the relevant bits go to the correct cost centre - IYSWIM !!!

Oh blimey Inky, Friday afternoon 15 mins before hometime.. :rotfl:I don't think you can but I'm sure there's something else you can use.. hang on...

Toto

Burlesque_Babe wrote: »

ta all. I guess I just have my cynical head on today

The thought of working there doesn't fill me with any excitement, but, as the merger has now slipped, I just can't afford to stay there anymore, but I love the place so much, it's like a family.

However, the job was 30 hours on one advert and 37 on another. 30 hours would be only 16k, so still would need lots of teaching and AQA on top (just not as much), so that's another aspect to consider.

I know I'm probably a bit slow, but isn't there any chance of a full time post where you are?

I really fancy fish and chips for tea. Actually I really fancy big fat chips dripping in oil and a kebab.

becky_rtw

Inky it depends - if you have excel 2007 you can use SUMIFS but any earlier and you need to do this I think:
[FONT=verdana,arial,helvetica,sans-serif][SIZE=-1][FONT=verdana,arial,helvetica,sans-serif][SIZE=-1][/SIZE][/FONT][/SIZE][/FONT] =SUMPRODUCT(B2:E2,--(B3:E3>3%),--(B4:E4>=2%))

Where:

1. array1 = B2:E2 - This is the array from whom
2. array2 = –(B3:E3>3%) - This is the first condition
3. array3 = –(B4:E4>=2%) - This is the second condition

Does that help?? Try googling SUMPRODUCT and see what help there is perhaps??