corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Morning


New Topic
New Poll 		  <<  1    2    3    4    5  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Morning
Pip308
Member
Registered: 25th Oct 07
Location: Basingstoke Drives: Audi A4 Avant, Mk1 Caddy
User status: Offline
25th May 10 at 08:42   View User's Profile U2U Member Reply With Quote


work is a little annoyed i didnt show up yesterday lol
Conway563
Member
Registered: 7th Jun 06
Location: Yate, Bristol
User status: Offline
25th May 10 at 08:45   View User's Profile U2U Member Reply With Quote
Mike
Tommy
Laura

New phone is waiting for me at home
Budgie
Member
Registered: 2nd Dec 09
Location: Basingstoke
User status: Offline
25th May 10 at 08:45   View User's Profile U2U Member Reply With Quote
i thought you phoned up on sunday phil?
Budgie
Member
Registered: 2nd Dec 09
Location: Basingstoke
User status: Offline
25th May 10 at 08:56   View User's Profile U2U Member Reply With Quote
anyone good in excel formulas (IF functions mainly)
Fro
Member
Registered: 20th Jun 06
Location: Rainham, Essex Drives: A3 2.0TDi Sport
User status: Offline
25th May 10 at 08:58   View User's Profile U2U Member Reply With Quote
I did a mother of an IF the other day,

=IF(M5>0,"COMPLETE",IF(K5>0,"SEND CUSTOMER DETAILS",IF(I5>0,"PREPARE FOR UPLOAD",IF(G5>0,"INDIA PROCESSING",IF(E5>0,"FILE REC'D","AWAITING FILE")))))


whats up?
Tommy L
Member
Registered: 21st Aug 06
Location: Northampton Drives: Audi wagon
User status: Offline
25th May 10 at 09:01   View User's Profile U2U Member Reply With Quote
Joseph
Budgie
Member
Registered: 2nd Dec 09
Location: Basingstoke
User status: Offline
25th May 10 at 09:02   View User's Profile U2U Member Reply With Quote
currently got a formula showing the turn around period of an item (date in - date out)
but one of our delivery managers wants it so its blank on the spreadsheet until we put the dates in if that makes sense
Fro
Member
Registered: 20th Jun 06
Location: Rainham, Essex Drives: A3 2.0TDi Sport
User status: Offline
25th May 10 at 09:30   View User's Profile U2U Member Reply With Quote
You could do it by leaving the false value blank. then you will only get a value when the criteria is true?

Edit: If thats no help you could send me a snippit copy of the sheet and ill have a play?

[Edited on 25-05-2010 by fro-dizzle]
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
25th May 10 at 09:34   View User's Profile U2U Member Reply With Quote
Fro, I will never forget the time when you were trying to right out a massive formula involving Ifs, averages, an array etc, and it was about twice as long as that one you posted, and I gave you a lookup formula about a fifth of the length
Fro
Member
Registered: 20th Jun 06
Location: Rainham, Essex Drives: A3 2.0TDi Sport
User status: Offline
25th May 10 at 09:37   View User's Profile U2U Member Reply With Quote
that was quite crazy!
Pip308
Member
Registered: 25th Oct 07
Location: Basingstoke Drives: Audi A4 Avant, Mk1 Caddy
User status: Offline
25th May 10 at 09:47   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Budgie
i thought you phoned up on sunday phil?


but they all know i wasnt actually ill....
Fro
Member
Registered: 20th Jun 06
Location: Rainham, Essex Drives: A3 2.0TDi Sport
User status: Offline
25th May 10 at 09:54   View User's Profile U2U Member Reply With Quote
tsk tsk.
Whittie
Member
Registered: 11th Aug 06
Location: North Wales Drives: BMW, Corsa & Fiat
User status: Offline
25th May 10 at 09:58   View User's Profile U2U Member Reply With Quote
Hiii
Budgie
Member
Registered: 2nd Dec 09
Location: Basingstoke
User status: Offline
25th May 10 at 09:58   View User's Profile U2U Member Reply With Quote
righto fro shall sort a spreadsheet out
Budgie
Member
Registered: 2nd Dec 09
Location: Basingstoke
User status: Offline
25th May 10 at 09:59   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Pip308
quote:
Originally posted by Budgie
i thought you phoned up on sunday phil?


but they all know i wasnt actually ill....

did you get spotted eye-ing up the girls on your 3mx
Whittie
Member
Registered: 11th Aug 06
Location: North Wales Drives: BMW, Corsa & Fiat
User status: Offline
25th May 10 at 10:04   View User's Profile U2U Member Reply With Quote
Ah talking of spreadsheets...

In Excel, how do I make a cell +30?

Basically, It's an invoice template, and I have one cell as "Today" and I want a payment due date to be 30 days on. Just wondering how its done, save a little time
Budgie
Member
Registered: 2nd Dec 09
Location: Basingstoke
User status: Offline
25th May 10 at 10:05   View User's Profile U2U Member Reply With Quote


hope that makes sense
Fro
Member
Registered: 20th Jun 06
Location: Rainham, Essex Drives: A3 2.0TDi Sport
User status: Offline
25th May 10 at 10:21   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Whittie
Ah talking of spreadsheets...

In Excel, how do I make a cell +30?

Basically, It's an invoice template, and I have one cell as "Today" and I want a payment due date to be 30 days on. Just wondering how its done, save a little time


=DATE(YEAR(B16),MONTH(B16),DAY(B16)+30)

edit: B16 = your date field.

[Edited on 25-05-2010 by fro-dizzle]
Budgie
Member
Registered: 2nd Dec 09
Location: Basingstoke
User status: Offline
25th May 10 at 10:34   View User's Profile U2U Member Reply With Quote
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
25th May 10 at 10:40   View User's Profile U2U Member Reply With Quote
*PUKE*
Budgie
Member
Registered: 2nd Dec 09
Location: Basingstoke
User status: Offline
25th May 10 at 11:07   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Neo
*PUKE*




How about this . . .
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
25th May 10 at 11:13   View User's Profile U2U Member Reply With Quote
Now that one is nice

[Edited on 25-05-2010 by Neo]
Fro
Member
Registered: 20th Jun 06
Location: Rainham, Essex Drives: A3 2.0TDi Sport
User status: Offline
25th May 10 at 11:30   View User's Profile U2U Member Reply With Quote
I get what you mean now mate, not too sure will have a good look into it when i get a mo as it would help with a couple of my sheets too.

Pizza hut just arrived
2 for 1 tuesday
Budgie
Member
Registered: 2nd Dec 09
Location: Basingstoke
User status: Offline
25th May 10 at 11:37   View User's Profile U2U Member Reply With Quote
Fro
Member
Registered: 20th Jun 06
Location: Rainham, Essex Drives: A3 2.0TDi Sport
User status: Offline
25th May 10 at 11:40   View User's Profile U2U Member Reply With Quote
NIOCE.

  <<  1    2    3    4    5  >>
New Topic
New Poll

Corsa Sport » Message Board » Off Day » Morning 22 database queries in 0.0179870 seconds