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

The paste game

24

Comments

  • ForeverAddickted
    ForeverAddickted Posts: 94,288
    =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))))))))))))
  • BR7_addick
    BR7_addick Posts: 10,210
    INTER-CO
  • cafc4life
    cafc4life Posts: 4,632
    do i have gonnorhea?
  • ForeverAddickted
    ForeverAddickted Posts: 94,288
    cafc4life said:

    do i have gonnorhea?

    This is a Charlton forum mate... No Arsenal fans here so far as am I'm aware
  • Sonicstud85
    Sonicstud85 Posts: 2,159
    Bolton v QPR
    Brentford v Derby
    Fulham v Charlton
  • man_at_milletts
    man_at_milletts Posts: 5,620
    a to the g and the f to the ...what comes next?
  • PL54
    PL54 Posts: 10,757

    Someone in a black and white scarf gets abused by a pisst Charlton fan
  • Oakster
    Oakster Posts: 6,812
    tortillas
  • Brendan_O_Connell
    Brendan_O_Connell Posts: 8,938
    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:
  • sam3110
    sam3110 Posts: 21,241
    http://www.f1fanatic.co.uk/2016/02/19/compare-ferraris-new-sf16-h-with-their-2015-car/
  • Sponsored links:



  • i_b_b_o_r_g
    i_b_b_o_r_g Posts: 18,948
    https://www.gov.uk/government/publications/terminate-an-appointment-of-a-director-tm01

    ; )
  • Karim_myBagheri
    Karim_myBagheri Posts: 12,691
    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 addick
    thai malaysia addick Posts: 18,332
    away
  • A-R-T-H-U-R
    A-R-T-H-U-R Posts: 7,678
    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
  • IA
    IA Posts: 6,103
    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 Neil
    North Lower Neil Posts: 22,943
    Streatfeild
  • stackitsteve
    stackitsteve Posts: 12,102
    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 Neil
    North Lower Neil Posts: 22,943
    28 Grosvenor Rd, Royal Tunbridge Wells, Tunbridge Wells, Kent TN1 2AP
  • ForeverAddickted
    ForeverAddickted Posts: 94,288
    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!
  • eaststandmike
    eaststandmike Posts: 14,956
    When are Sheff Utd going to come good?
  • Sponsored links:



  • ForeverAddickted
    ForeverAddickted Posts: 94,288
    ADAPTED from I Had To Survive
  • BR7_addick
    BR7_addick Posts: 10,210
    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.
  • ForeverAddickted
    ForeverAddickted Posts: 94,288
    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?
  • LouisMend
    LouisMend Posts: 5,446
    x-maps-mapitemhandles://YnBsaXN0MDDSAQIDBV8QFk1LTWFwSXRlbUxhdW5jaEhhbmRsZXNfECVNS01hcEl0ZW1MYXVuY2hBZGRpdGlvbnNMYXVuY2hPcHRpb25zoQRPEOUIARLgARoSCTkKEAUz40pAEQkWhzO/qgXAIoQBCg5Vbml0ZWQgS2luZ2RvbRICR0IaB0VuZ2xhbmQqCkxhbmNhc2hpcmUyB1ByZXN0b246B1BSMiAzRUJCB0Z1bHdvb2RSDUdhcnN0YW5nIFJvYWRaAzExMWIRMTExIEdhcnN0YW5nIFJvYWRyDUdyZWF0IEJyaXRhaW6KAQdGdWx3b29kKhExMTEgR2Fyc3RhbmcgUm9hZDIRMTExIEdhcnN0YW5nIFJvYWQyB1ByZXN0b24yB1BSMiAzRUIyB0VuZ2xhbmQ4OUAA0QYHXxAkTUtMYXVuY2hPcHRpb25zUmVmZXJyYWxJZGVudGlmaWVyS2V5XxATY29tLmFwcGxlLm1vYmlsZWNhbAAIAA0AJgBOAFABOAE7AWIAAAAAAAACAQAAAAAAAAAIAAAAAAAAAAAAAAAAAAABeA==
  • Atletico Addick
    Atletico Addick Posts: 5,843
    Sport Shield Group Consortium
  • Its_Hamer_Time
    Its_Hamer_Time Posts: 1,565
    One is swollen, and the other has gone blue
  • PL54
    PL54 Posts: 10,757
    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.
  • RedPanda
    RedPanda Posts: 4,982
    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)
  • Addickted2TheReds
    Addickted2TheReds Posts: 7,735

    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

  • LuckyReds
    LuckyReds Posts: 5,866
    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)

Categories

“Marketplace”