Writing It in Excel

The most bizarre coding interview I've ever done was at Facebook when as usual I asked a candidate to write in any language of their choice.. And they nonchalantly said "I'll write it in Excel", to which I almost let loose a chuckle until... levels'!$C$6:$C$28,"Update stock levels'!$D$6:$D$28)="", IF(IF(OR($A101=6, $A101=7), D100, D100 $3,'Daily usage'!$A:$A,'Daily usage'!$C:$C)<0, IF(OR($A101=6, $A101=7), D100, D100+SUMIFS('Daily usage'!$A:$A,'Daily usage'!$C:$C)), XLOOKUP(Model!$D$3,'Update stock levels'!$C$6:$C$28,'Update stock levels'!$D$6:$D$28)+SUMIFS('Delivery data'!$D:$D,'Delivery data'!$A:$A,Model!$D$3,'Delivery data'!$C:$C,Model!$B101)- SUMIFS('Delivery data'!$D:$D,'Delivery data'!$A:$A,Model!$D$3,'Delivery data'!$C:$C,Model!$B101)-

A tweet describes a bizarre coding interview at Facebook where a candidate chose Excel as their programming language. The punchline is a huge, complicated spreadsheet formula that proves Excel can be used like a programming language, making the interviewer’s chuckle disappear.

• @dev_meme / 6395 2024-11-20