Many use Excel for basic tables, but you need to go beyond simple sums. If your formulas are getting clunky, conditional functions are the smarter, hidden-in-plain-sight option. They handle complex ...

TV and home video editor Ty Pendlebury joined CNET Australia in 2006, and moved to New York City to be a part of CNET in 2011. He tests, reviews and writes about the latest TVs and audio equipment.