Click here for Arsenal FC news and reports

Results 1 to 10 of 27

Thread: Genuine question. If No Deal Brexit, do I have any right to stay in France after the

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Quote Originally Posted by Ash View Post
    You mean they don't indent and comment their code properly?
    Have you ever watched ‘Silicon Valley’, a?

    There’s a whole bit where a lead character breaks up with a new girlfriend because she doesn’t indent.

  2. #2
    Quote Originally Posted by Burney View Post
    Have you ever watched ‘Silicon Valley’, a?

    There’s a whole bit where a lead character breaks up with a new girlfriend because she doesn’t indent.
    =IF($Q27=1,IF(OR(AND($N27<W$4,$O27<W$4),AND($N27>W $5,$O27>W$5)),0,1),IF($Q27=2,IF(OR(AND($N27<W$8,$O 27<W$8),AND($N27>W$9,$O27>W$9)),0,1),IF($Q27=3,IF( OR(AND($N27<W$12,$O27<W$12),AND($N27>W$13,$O27>W$1 3)),0,1),IF($Q27=4,IF(OR(AND($N27<W$16,$O27<W$16), AND($N27>W$17,$O27>W$17)),0,1)))))

    This is what happens when you have to write a complex conditional cell expression in Excel. It fits bookings into time-slots and the only way to design it was to write it in beautifully-indented pseudo-code so I could literally see the logical flow, then turn it into the gibberish up there.

  3. #3
    Quote Originally Posted by Ash View Post
    =IF($Q27=1,IF(OR(AND($N27<W$4,$O27<W$4),AND($N27>W $5,$O27>W$5)),0,1),IF($Q27=2,IF(OR(AND($N27<W$8,$O 27<W$8),AND($N27>W$9,$O27>W$9)),0,1),IF($Q27=3,IF( OR(AND($N27<W$12,$O27<W$12),AND($N27>W$13,$O27>W$1 3)),0,1),IF($Q27=4,IF(OR(AND($N27<W$16,$O27<W$16), AND($N27>W$17,$O27>W$17)),0,1)))))

    This is what happens when you have to write a complex conditional cell expression in Excel. It fits bookings into time-slots and the only way to design it was to write it in beautifully-indented pseudo-code so I could literally see the logical flow, then turn it into the gibberish up there.
    I got a little pang of pride when this worked this morning

    =IFERROR((ROUND(INDEX('Labour'!$BO$4:$CO$215,MATCH ($A17,'Labour'!$BO$4:$BO$215,0),MATCH('req'!E$7,'L abour'!$BO$4:$CO$4,0)),0)),0)

    “Other clubs never came into my thoughts once I knew Arsenal wanted to sign me.”

  4. #4
    Quote Originally Posted by IUFG View Post
    I got a little pang of pride when this worked this morning

    =IFERROR((ROUND(INDEX('Labour'!$BO$4:$CO$215,MATCH ($A17,'Labour'!$BO$4:$BO$215,0),MATCH('req'!E$7,'L abour'!$BO$4:$CO$4,0)),0)),0)

    Which elderly woman with a disability on a minimum wage did that fire, IUFG?

  5. #5
    Quote Originally Posted by WES View Post
    Which elderly woman with a disability on a minimum wage did that fire, IUFG?
    We use a random number generator for that, w
    “Other clubs never came into my thoughts once I knew Arsenal wanted to sign me.”

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •