Weird new passion: MS Excel

I thought I knew MS Excel pretty well, having mastered pivot tables and VLOOKUP (and other assorted functions).

For the last month or so, I've been finding new tricks every single day at work. I usually just use Google to find an answer for the issue of the moment. Just like in real life.

I've been trying to keep track of the tips, but haven't found the right medium. Maybe this is it. Haven't used LJ in months, since Facebook has reduced my attention span even more.

Use .xlsb instead of .xlsx to save space

( Tip: Excel Binary Workbook )

a1=4; =if(a1=5,"y") returns FALSE. =if(a1=5,"y",) returns 0

( IF statement can return 0 instead of FALSE )