Thats the last Excel formula I wrote! How about yourself?

=SUM(A1,A9)

donât @ me

=SUM(E28:I28)

ctrl+f

=IF(I19<>0,IF(D19<=I19,IF(I19>0,D19/I19,-1-(D19-I19)/I19),IF(D19>=I19,IF(I19>0,D19/I19,(1+((D19-I19)/(I19*-1)))),D19/I19)),0)

Oh I didnât write that, but it is the last I c&pâŚ and it isnât in excel. Sorry!

=IF($J$12=1,E15,IF($J$12=2,E16,E17))

=IFNA(INDEX(âFeatured Playersâ!$F$13:$F$2010,MATCH(âActor Statsâ!E12,âFeatured Playersâ!$D$13:$D$2010,0)),â0â)

=159395/6

My boss literally asks people what their favourite spreadsheet formula is in interviews

I had an employer ask what my favourite excel shortcut was once. I said Ctrl Z

I mean, ask a stupid questionâŚ

I said cntrl f

=$C$34*($C$34/$F$34)*(C36/$F$34)*I36/10000

=minifs(âRaw answersâ!B:B,âRaw answersâ!F:F,âSalesâ)

Gotta love a good *ifs condition