Attention: Please take a moment to consider our terms and conditions before posting.

The paste game

24

Comments

  • BR7_addickBR7_addick
    INTER-CO
  • cafc4lifecafc4life
    do i have gonnorhea?
  • ForeverAddicktedForeverAddickted
    cafc4life said:

    do i have gonnorhea?

    This is a Charlton forum mate... No Arsenal fans here so far as am I'm aware
  • Sonicstud85Sonicstud85
    Bolton v QPR
    Brentford v Derby
    Fulham v Charlton
  • man_at_millettsman_at_milletts
    a to the g and the f to the ...what comes next?
  • PL54PL54

    Someone in a black and white scarf gets abused by a pisst Charlton fan
  • OaksterOakster
    tortillas
  • Brendan_O_ConnellBrendan_O_Connell
    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    If you're copying and pasting those formulas you are cheating!! You should be writing them in as you go along! :wink:
  • sam3110sam3110
    http://www.f1fanatic.co.uk/2016/02/19/compare-ferraris-new-sf16-h-with-their-2015-car/
  • Sponsored links:


  • Karim_myBagheriKarim_myBagheri
    PL54 said:


    Someone in a black and white scarf gets abused by a pisst Charlton fan

    you cut and pasted your own post?
  • thai malaysia addickthai malaysia addick
    away
  • A-R-T-H-U-RA-R-T-H-U-R
    What's the legal age of consent because I am an International football player with a beautiful girlfriend and so incredibly stupid it defies belief, please Siri
  • IAIA
    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    You need to learn how to do vlookups.

    However, if you're going with this format, there is a clear error in the 2nd/3rd lines.

    My Friday night is going great, thanks.
  • North Lower NeilNorth Lower Neil
    Streatfeild
  • stackitstevestackitsteve
    IA said:

    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    You need to learn how to do vlookups.

    However, if you're going with this format, there is a clear error in the 2nd/3rd lines.

    My Friday night is going great, thanks.
    Why would you have copied that?
  • North Lower NeilNorth Lower Neil
    28 Grosvenor Rd, Royal Tunbridge Wells, Tunbridge Wells, Kent TN1 2AP
  • ForeverAddicktedForeverAddickted
    IA said:

    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    You need to learn how to do vlookups.

    However, if you're going with this format, there is a clear error in the 2nd/3rd lines.

    My Friday night is going great, thanks.
    Didnt need to do the VLOOKUPs for that particular cell... Paranoid over the error now as the formula worked fine lol!
  • eaststandmikeeaststandmike
    When are Sheff Utd going to come good?
  • Sponsored links:


  • ForeverAddicktedForeverAddickted
    ADAPTED from I Had To Survive
  • BR7_addickBR7_addick
    North Lower Neil said:

    28 Grosvenor Rd, Royal Tunbridge Wells, Tunbridge Wells, Kent TN1 2AP

    I've also been looking at hotels in Tunbridge Wells this morning.
  • ForeverAddicktedForeverAddickted
    BR7_addick said:

    North Lower Neil said:

    28 Grosvenor Rd, Royal Tunbridge Wells, Tunbridge Wells, Kent TN1 2AP

    I've also been looking at hotels in Tunbridge Wells this morning.
    Ooo are there two Lifers planning a secret lil rendezvous?
  • LouisMendLouisMend
    x-maps-mapitemhandles://YnBsaXN0MDDSAQIDBV8QFk1LTWFwSXRlbUxhdW5jaEhhbmRsZXNfECVNS01hcEl0ZW1MYXVuY2hBZGRpdGlvbnNMYXVuY2hPcHRpb25zoQRPEOUIARLgARoSCTkKEAUz40pAEQkWhzO/qgXAIoQBCg5Vbml0ZWQgS2luZ2RvbRICR0IaB0VuZ2xhbmQqCkxhbmNhc2hpcmUyB1ByZXN0b246B1BSMiAzRUJCB0Z1bHdvb2RSDUdhcnN0YW5nIFJvYWRaAzExMWIRMTExIEdhcnN0YW5nIFJvYWRyDUdyZWF0IEJyaXRhaW6KAQdGdWx3b29kKhExMTEgR2Fyc3RhbmcgUm9hZDIRMTExIEdhcnN0YW5nIFJvYWQyB1ByZXN0b24yB1BSMiAzRUIyB0VuZ2xhbmQ4OUAA0QYHXxAkTUtMYXVuY2hPcHRpb25zUmVmZXJyYWxJZGVudGlmaWVyS2V5XxATY29tLmFwcGxlLm1vYmlsZWNhbAAIAA0AJgBOAFABOAE7AWIAAAAAAAACAQAAAAAAAAAIAAAAAAAAAAAAAAAAAAABeA==
  • Atletico AddickAtletico Addick
    Sport Shield Group Consortium
  • Its_Hamer_TimeIts_Hamer_Time
    One is swollen, and the other has gone blue
  • PL54PL54
    Karim_myBagheri said:

    PL54 said:


    Someone in a black and white scarf gets abused by a pisst Charlton fan

    you cut and pasted your own post?
    If you remember, which you clearly do, it topped and tailed my woefully wrong match prediction. Too busy for double typing.
  • RedPandaRedPanda
    Nottata e mattinata agitate per il Milan e per Mario Balotelli, prima della grande sfida di stasera con il Napoli. In ritiro come sempre nella storica sede dell'Hotel Vesuvio, la squadra rossonera ha ricevuto la visita di un numeroso gruppo di tifosi azzurri - sui trecento, età media molto bassa - che hanno cominciato a bivaccare, facendo rumore con cori contro la squadra, e trombette. E i cori contro il Milan presto si sono diretti contro l'attaccante, che dalla sua stanza si sarebbe affacciato, rispondendo con un gestaccio. Una replica che non è stata apprezzata dai presenti e che ha fatto aumentare il volume della protesta. La polizia, che era già in zona, ha monitorato da vicino l'accaduto contribuendo a placare gli animi della folla assiepata sull'isola pedonale che circonda l'albergo, in cui sta soggiornando anche De Laurentiis.

    (300 Napoli fans spent last night outside AC Milan's hotel making noise. Mario Balotelli swore at them and made it worse)
  • Addickted2TheRedsAddickted2TheReds

    Available in resort (for free)

    Bed linen
    Towels
    Dish towels
    Final cleaning (excl. kitchen)
    Cleaning pack
    TV
    Wifi (limited data volume)

    Payable in resort

    Tourist tax: approx. € 1,00 per person/night
    Deposit: €200 apartment

    Available in resort (optional)

    Use of fitness/spa area in the Résidence Les Temples du Soleil (see description)
    Baby facilities
    Underground parking (based on availability): €70/week

  • LuckyRedsLuckyReds
    edited February 2016
    ForeverAddickted said:

    =IF(I6=I20,AA4,
    IF(I6=J20,AA13,
    IF(I6=J20,AI4,
    IF(I6=L20,AI13,
    IF(I6=M20,AQ4,
    IF(I6=N20,AQ13,
    IF(I6=O20,AY4,
    IF(I6=P20,AY13,
    IF(I6=Q20,BG4,
    IF(I6=R20,BG13,
    IF(I6=S20,BO4,
    IF(I6=T20,BO13))))))))))))

    Jesus, what's that monstrosity, Excel I guess? (if(<predicate>, <true>, <false>)?) Stunning how an office application is more archaic than some programming languages!

    (pssst.. if I6 is equal to K20, it'll output BO13 and there's no way AI4 will ever output)
Sign In or Register to comment.

Roland Out Forever!