Excelling in the field of logic (NLC)

mac · Post by **mac** » Mon Aug 07, 2006 11:58 am

Any expert Windows Excel users out there? I'm trying to input a logical function but I can only get half of it to work.

Basiclly I want a cell to validate dates and flag up if something was received late. It needs to compare the actual date against the scheduled date and also todays date.

In simpler terms if the recieved date or todays date is later than the scheduled date it puts "overdue" in a box - I can get most of it to work - the problems arise when the received date box is empty.

if anyone can help please PM me and I'll phone to discuss properly.

Cheers

Mac

Sanjøy · Post by **Sanjøy** » Mon Aug 07, 2006 12:01 pm

Afraid I cannot speak on the phone but look up vert lookup tables.

Lazydonkey · Post by **Lazydonkey** » Mon Aug 07, 2006 1:26 pm

mac - if you send me it at "martin dot thorn at scottishpower dot plc dot uk " I'll do it for you.

You just need to do it using nested If statements with an Iserror thrown in for good measure.

ie. If(x=y,(if(x=j,0,1),o)

Much easier for me to do it and send it back than explain it

In meetings from 2-4 but can do it after that if that helps

ninja · Post by **ninja** » Mon Aug 07, 2006 4:39 pm

you can make it change the cell colour too so if it's late the cell turns red!!

don't know how to do this just some w*nker in the office does that on his RFI sheets.

ninja

mac · Post by **mac** » Mon Aug 07, 2006 4:42 pm

I can do that if it's simple enough - obviously not a big enough W@nker. Fortunatly Lazy Donkey is on the case - and as a VW owner fits the criteria

Mac

Lazydonkey · Post by **Lazydonkey** » Mon Aug 07, 2006 9:44 pm

Didn't see your email when i came out of my meetings mac - did you send it ? Maybe it's just being slow - i'll check tomorrow morning when i get in.

Oh and i'm a Vauxhall owner not VW owner

Lazydonkey · Post by **Lazydonkey** » Mon Aug 07, 2006 10:46 pm

Jesus i have too much time on my hands...........

............and i'm FAR too fond of functions in excel

http://www.lazydonkey.co.uk/mac_file.xls

mac · Post by **mac** » Tue Aug 08, 2006 8:17 am

Cheers Martin.

Just one wee issue - if it's received before the schedule date it's still shows as overdue.

Mac

Lazydonkey · Post by **Lazydonkey** » Tue Aug 08, 2006 8:44 am

B*gger

That was working til i got all fancy - ill do it just now

EDIT : All fixed, but all you excel fans out there will have to wait for tonight before i post the solution

And yes I really am that sad that i enjoy this sh*t but it's my job so that's ok

mac · Post by **mac** » Tue Aug 08, 2006 10:52 am

Thanks Martin.

Your a star (in a low cost lotus)

Mac

Lazydonkey · Post by **Lazydonkey** » Tue Aug 08, 2006 11:42 am

I happen to love my low cost lotus with its cheap insureance and cheap servicing

mac · Post by **mac** » Tue Aug 08, 2006 12:00 pm

Not as cheap as the guy I use to service my car -

Wait that doesn't sound right........

Mac