Mon, 2 November 2009 Nick asks how to do a pretty lengthy bonus calculation. It might be too
complex for the Excel 2003 nested IF limit, so I decided to use the
range version of VLOOKUP. But...as a twist, I embed the table right in
the formula. Episode 1135 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! |
Learn Excel from MrExcel Video Podcast
Learn Excel from Bill Jelen with this daily 2 minute video podcast!
Bill Jelen
MrExcel Podcast Blog
Buy The Learn Excel Podcast DVD
Categories
podcastsArchives
JanuaryFebruary
March
April
May
June
July
August
September
October
November
January
February
March
April
May
June
July
August
September
October
November
December
January
February
March
April
May
June
July
August
September
October
November
December
January
February
March
April
May
June
July
August
September
October
November
December
Syndication
